Hi all, I have a file with the following breakdown:
Column A: A2-A18 -- list of individual countries
Column B: B2-B18 -- countries average scores from a survey we performed
Column C: rank formula =IF(A2="","", RANK(B2,$B$2:$B$18,1)+COUNTIF(B2,B2)-1)
There are 2 problems with the formula, it lists the highest score with a 17, I want it to have the highest score with a 1, lowest with 17.
Secondly, there are 2 occurrences where the average scores are the same. I need the rank formula to not have a duplicate number in there, for example (Dallas and Tokyo both have scores of 73.64, both ranked 6 in Column C, but I need a formula to list Dallas at 6 and Tokyo at 7 so it follows alphabetically).
Could someone help me??? I'm frustrated my efforts haven't worked so far. THANK YOU!!!
Bookmarks