easy5 pts · first answer countsexcelstatistical-functions

Ranking salespeople

Sales are in B2:B20. Which formula in C2 ranks the person in row 2, with the highest sales as rank 1?

A.=RANK.EQ(B2,$B$2:$B$20)B.=RANK.EQ($B$2:$B$20,B2)C.=RANK.EQ(B2,B2:B20,1)D.=LARGE(B2,$B$2:$B$20)

Discussion 0

Join free to post in the discussion.