Forum Discussion
Grassland79
Dec 31, 2024Copper Contributor
Ranking data in Excel
Hi there. If I have data in Column A for 5 teams (say batting average), how do I get column B to be the ranking of those averages? For instance, if A2 = .390, A3 = .295, A4 = .401, A5 = .227, A6 = ...
HansVogelaar
Jan 02, 2025MVP
In B2:
=RANK.EQ(A2:A6, A2:A6)
This will spill to B2:B6.