multiple arrays for SMALL command

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chickalett - 16 Mar 2006 15:08 GMT

How do I use the SMALL command when I want it to look at values liste
on different sheets? The problem is that it won't let me list more tha
one array like the minimum command allows me. Or is there some way t
list cell numbers inside a bracketed array instead of values? Fo
example, I can do:
=SMALL({6,23,5,2.3}, 2)
but I can't do:
=SMALL({A3,C5,D18,D21}, 2)
which is what I need to be able to do.
Is there another command I can use

--
Chickalett

Reply to this Message

akyurek@xs4all.nl - 16 Mar 2006 19:55 GMT

=SMALL((A3,C5,D18,D21), 2)

Reply to this Message

Chickalett - 21 Mar 2006 03:46 GMT

akyurek@xs4all.nl Wrote:

> =SMALL((A3,C5,D18,D21), 2)

Thanks,
What if my values are on different sheets, like for instance:
=SMALL((A3,C5,D18,Sheet2!A2,Sheet3!A1), 2)
It doesn't seem to work then

--
Chickalett

Reply to this Message

Aladin Akyurek - 23 Mar 2006 08:31 GMT

If you download and install the morefunc.xll add-in (try google to
locate)...

=SMALL(ARRAY.JOIN(A3,C5,D18,Sheet2!A2,Sheet3!A1), 2)

> akyurek@xs4all.nl Wrote:
>
[quoted text clipped - 4 lines]
> =SMALL((A3,C5,D18,Sheet2!A2,Sheet3!A1), 2)
> It doesn't seem to work then.

Reply to this Message

Alan Beban - 16 Mar 2006 20:03 GMT

> How do I use the SMALL command when I want it to look at values listed
> on different sheets? The problem is that it won't let me list more than
[quoted text clipped - 6 lines]
> which is what I need to be able to do.
> Is there another command I can use?

Use parentheses instead of braces.

Alan Beban

Reply to this Message

Chickalett - 21 Mar 2006 03:47 GMT

Alan Beban Wrote:

> How do I use the SMALL command when I want it to look at value
> listed
[quoted text clipped - 12 lines]
>
> Alan Beban

Thanks,
What if my values are on different sheets, like for instance:
=SMALL((A3,C5,D18,Sheet2!A2,Sheet3!A1), 2)
It doesn't seem to work then

--
Chickalett

Reply to this Message