Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Rank with If
Column B contains numbers.
Column C should rank numbers in Column B, but only for sets of data matched by the Xs (X, XX, XXX, XXXX, etc.) In other words, rank all figures in Column B for X, then rank all figures in Column B for XXm, etc... Thanks for your help! Column A Column B Column C X 2 X X X X X XX XX XX XX XXX XXX XXX XXX XXX XXX XXX XXXX XXXX XXXX XXXX XXXXX XXXXX XXXXX XXXXX XXXXX XXXXXX XXXXXX XXXXXX XXXXXX XXXXXX XXXXXX XXXXXXX |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
RANK formula | Excel Discussion (Misc queries) | |||
How can I rank numbers based on other numbers? | Excel Worksheet Functions | |||
Rank fx - Fill Down? | Excel Worksheet Functions | |||
Rank() based on category | Excel Worksheet Functions |