Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RANK
I am currently using the rank function to highlight the best performers.
I am then trying to create a league table on a seperate sheet. I have a list of 1-20 in column A and are then using VLOOKUP to result the person who is ranked that number. The problem I am haveing is when 2 people are ranked say 3 it obviously finds the first result of 3 and then results N/A against 4. Is there anyway I can put the same ranked people into say alphabetical order and each person to then be ranked in accordence (if you understand what i mean) Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RANK
One way is to use the RANK formula to give unique ranks. This breaks ties
on position, but if your names are already sorted alphabetically, then that should match what you ask for. entered in C21, then drag filled down the column. =RANK(B21,$B$21:$B$26)+COUNTIF($B$21:B21,B21)-1 -- Regards, Tom Ogilvy "TheRook" wrote in message ... I am currently using the rank function to highlight the best performers. I am then trying to create a league table on a seperate sheet. I have a list of 1-20 in column A and are then using VLOOKUP to result the person who is ranked that number. The problem I am haveing is when 2 people are ranked say 3 it obviously finds the first result of 3 and then results N/A against 4. Is there anyway I can put the same ranked people into say alphabetical order and each person to then be ranked in accordence (if you understand what i mean) Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 where lowest value is highest rank | Excel Worksheet Functions | |||
Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |