| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank using another column for tiebreaker
I am trying to figure out how to use another column as a tiebreaker when
using the rank feature. For example: Column A Column B Rank 150 55 3 362 65 5 251 67 6 119 55 3 167 87 8 225 44 1 269 83 7 198 44 1 I want to rank Column B but if there is a tie, I want to look at column A to break that tie. Can you help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rank a quantity column using a pivot table | Excel Discussion (Misc queries) | |||
| Rank and return column header | Excel Discussion (Misc queries) | |||
| Rank a column but not include some cells | Excel Discussion (Misc queries) | |||
| how can i rank a column in excel | Excel Worksheet Functions | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
Threaded Mode
