Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ranking
I am wanting to rank data in a spreadsheet. I am using the RANK function
which is working ok is non of the results are equal. If the results are equal they ranking position is the same. Is there anyway that if 2 results are equal and are both ranked No. 15, that it ranks the as 15 and 16. The reason I am wanting this is becasue I am also using the Lookup function else where to list all the different rankings from different areas, from 1 through to 100. As at present it would rank both results as 15, the lookup funtion would only report the 1st result against No. 115 and nothing against 16. Can anyone help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ranking
=RANK(B1,$B$1:$B$10,1)+COUNTIF($B$1:$B1,B1)-1
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "TheRook" wrote in message ... I am wanting to rank data in a spreadsheet. I am using the RANK function which is working ok is non of the results are equal. If the results are equal they ranking position is the same. Is there anyway that if 2 results are equal and are both ranked No. 15, that it ranks the as 15 and 16. The reason I am wanting this is becasue I am also using the Lookup function else where to list all the different rankings from different areas, from 1 through to 100. As at present it would rank both results as 15, the lookup funtion would only report the 1st result against No. 115 and nothing against 16. Can anyone help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranking | Excel Worksheet Functions | |||
Ranking | Excel Worksheet Functions | |||
Ranking? | Excel Discussion (Misc queries) | |||
ranking | Excel Worksheet Functions | |||
ranking | Excel Worksheet Functions |