| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking numbers
After a quick edit, this is what my original post should look like!!
I need to rank the following numbers: Entered Values Current Excel rank What I want 1 2 2 15 7 7 28 9 9.5 5 4 4 28 9 9.5 10 6 6.5 10 6 6.5 2 3 3 0 1 0 56 10 10 This is for a fishing score data. The weight is the 'Entered Values' (and is changeable week to week). I can get around the '0' that i actually want (there might of course be another way), but am really struggling to get the .5's sorted. Any help will be greatly apprieciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ranking numbers | Excel Discussion (Misc queries) | |||
| ranking a colum of numbers | Excel Worksheet Functions | |||
| Ranking changing numbers | Excel Discussion (Misc queries) | |||
| Numbers used for Ranking | Excel Worksheet Functions | |||
| Problem with ranking numbers | Excel Worksheet Functions | |||
Threaded Mode
