Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiple arrays for SMALL command
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 one array like the minimum command allows me. Or is there some way to list cell numbers inside a bracketed array instead of values? For 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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple arrays for SMALL command
=SMALL((A3,C5,D18,D21), 2)
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple arrays for SMALL command
Chickalett wrote:
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 one array like the minimum command allows me. Or is there some way to list cell numbers inside a bracketed array instead of values? For 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? Use parentheses instead of braces. Alan Beban |
#4
|
|||
|
|||
Quote:
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. |
#5
|
|||
|
|||
Quote:
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple arrays for SMALL command
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) Chickalett wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a single vertical array from multiple column arrays | Excel Worksheet Functions | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
How do I avoid multiple icons of Excel when using short command Al | Excel Discussion (Misc queries) | |||
Can you delete multiple worksheets with one command? | Excel Worksheet Functions | |||
averaging specific rows in multiple arrays | Excel Worksheet Functions |