| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rank scores show ties and add top four scores
Trying to rank a list of scores this way. So it will show the ties.
Then I need to add the top 4 and sum together. number ranking 2 1 3 2 3 2 5 3 6 4 so on First problem However using the rank formula does not give this result I've tried something like this =SUM(INDEX(LARGE(F6:F29,ROW(1:4)),0)) this gives me number rank 2 1 3 2 3 3 5 4 6 5 Then not sure how to grab tthe top four I tried |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ties using Rank Function | Excel Worksheet Functions | |||
| Need to rank values with ties | Excel Worksheet Functions | |||
| Auto Numbering Test Scores and want ties to count the same | Excel Worksheet Functions | |||
| Rank without skipping for ties | Excel Worksheet Functions | |||
| excel golf scores, how do I add the scores for all par 3's etc | Excel Worksheet Functions | |||
Threaded Mode
