Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rank the Data
Is there any way to rank the data using a macro, or is there an easier
way? Basically I have a list of data sorted by state. I want to rank the data from high to low(1st, 2nd, or 1,2, etc.), but not sort the data (I want it to stay where it is with the rank to the right of the data). How can I do this? Thanks, Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rank the Data
It is easier than you might suppose: there is a RANK() function that will do
it for you: =RANK($A1,$A1:$A50) will show A1's rank out of the list in A1-A50. NOTE: ties are possible, so RANK will give them equal ranks and then skip the next one - e.g. if there is a tie for 3rd rank, the rank numbers would go 1, 2, 3, 3, 5, 6 .... -- - K Dales "dm16s" wrote: Is there any way to rank the data using a macro, or is there an easier way? Basically I have a list of data sorted by state. I want to rank the data from high to low(1st, 2nd, or 1,2, etc.), but not sort the data (I want it to stay where it is with the rank to the right of the data). How can I do this? Thanks, Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the next same rank in data | Excel Discussion (Misc queries) | |||
transforming rank data | Excel Discussion (Misc queries) | |||
rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |