Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank Function: Refer to more than one range
Hi
I would like to enter a RANK functino that refers to more than one range when performing the rank calculation - is this possible? e.g. I have numbers in A1:A10 and in C5:C15. Can I do a rank that ranks a value in A5, say, in terms of its order within ranges A1:A10 and C5:C15 combined? e.g. something like =rank(A5,{A1:A10,C5:C15}) ^note the above formula doesn't work but I hope illustrates the problem I'm trying to solve. Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
Refer to Date/Time Range | Excel Worksheet Functions | |||
Refer to Named Range on another sheet for IF function | Excel Worksheet Functions | |||
How do I refer a Range to a Cell | Excel Worksheet Functions | |||
How do I refer to a non-empty row range in Excel | Excel Discussion (Misc queries) |