Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking numbers
try:
=RANK(A1,$A$1:$A$10,1)+(COUNT($A$1:$A$10) + 1 - RANK(A1,$A$1:$A$10, 0) - RANK(A1, $A$1:$A$10, 1))/2 This is using correction factor as described in HELP for RANK function. HTH "Joff" wrote: I need to rank the following numbers: Entered Values What Excel has ranked What I actually 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display the numerical ranking of a row of numbers in another row | 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 |