Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking a list
Hi
I have a list of values that I need to rank in descending order. Usually the RANK function is OK, but here is my problem. I need the list to use 'generous' rules. If there is a tie for 2nd, lets say, then I need the next place to be 3rd, NOT 4th as the RANK function does. eg Scores Rank(correct) Rank(wrong) 14.04 1 1 12.665 2 2 12.665 2 2 11.725 3 4 0.000 4 5 Any ideas how I can deal with this situation? Thanks in advance Bri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
List box setup, placement, and functionality | New Users to Excel | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |