Home |
Search |
Today's Posts |
#1
|
|||
|
|||
rank/small with multiple ranges
I'd like to refer to 3 different ranges of numbers and
make a new list which(when copying down the formula) creates a list of all the numbers in ascending order. Can I use the rank function across multiple ranges? say a1-a10, c1-c10, and e1-e10(so you can't highlight the whole rnge in one shot) and make g1 show the smallest number in all the ranges, g2 show the second smallest, etc. tia, Dave |
#2
|
|||
|
|||
Enter this & fill down 30 rows:
=LARGE(($A$1:$A$10,$C$1:$C$10,$E$1:$E$10),ROW(A1)) "dave" wrote in message ... I'd like to refer to 3 different ranges of numbers and make a new list which(when copying down the formula) creates a list of all the numbers in ascending order. Can I use the rank function across multiple ranges? say a1-a10, c1-c10, and e1-e10(so you can't highlight the whole rnge in one shot) and make g1 show the smallest number in all the ranges, g2 show the second smallest, etc. tia, Dave |
#3
|
|||
|
|||
thanks - I switched it to small for my purposes. Perfect!
-----Original Message----- Enter this & fill down 30 rows: =LARGE(($A$1:$A$10,$C$1:$C$10,$E$1:$E$10),ROW(A1) ) "dave" wrote in message ... I'd like to refer to 3 different ranges of numbers and make a new list which(when copying down the formula) creates a list of all the numbers in ascending order. Can I use the rank function across multiple ranges? say a1-a10, c1-c10, and e1-e10(so you can't highlight the whole rnge in one shot) and make g1 show the smallest number in all the ranges, g2 show the second smallest, etc. tia, Dave . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I auto-filter multiple ranges on one worksheet? | Excel Worksheet Functions | |||
Sorting Multiple Ranges | Excel Worksheet Functions | |||
Pivot Table-Using Multiple SS's or Ranges? | Excel Discussion (Misc queries) | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel |