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 |
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 |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com