I've looked at many of the threads and tried all the formulas, but I still can't seem to get this right. Maybe there's something really simple and I'm just missing it, but here's the problem.
I've four columns (Rank, Name, Score, %) and I've already sorted the data (First by Score, then % (as a tiebreaker), then name (so that it's alphabetical), but now in the first column I need the data ranked automatically.
I need the final product to look something like this:
1. Annie 140 80.20
1. Sarah 140 80.20
3. Rena 140 79.45
4. Paul 139 80.20
5. Cara 138 79.45
5. Lara 138 79.45
7. Tara 137 81.90
So I need the 1,1,3,4,5,5 column where it ranks the data according to score first and then percentage and if there are ties, it leaves them there.
Am I missing something obvious? Thanks for any help!
Bookmarks