The data I am working with is quite large but the example attached is just a snippet - In the source data, Col B has 7 different programmes and Col C ranges from 0 - 10.
I am trying to rank some data based on 2 criterion (Col B & C).
=COUNTIFS($B$2:$B$153,B2,$C$2:$C$153,">"&C2)+1
This formula I am using in Col D works but where there are duplicates it rightly ranks them the same number. Unfortunately since there are duplicates, the ranking skips numbers. What formula should I use to rank the duplicates the same and then use the next consecutive number versus skipping?
Each category has to be ranked separately. e.g. All the sports ranked separately from the Play
If I filter on the sport programme in the example attached, there are 25 number 1's, the next ranking is 26.. How do I get the formula to disregard the number of duplicates and give me the next rank as 2?
Please see the data attached spreadsheet.
Think of it as a race with varying finishing times and you want to rank the competitors on their finish time based on ***. So the first male time would be ranked 1 and so would be the first female time despite the finishing times varying etc. But if there are 2 males ranked number 1, I'd still want the next finish time to be ranked as 2 instead of the common ranking where you skip a number/s.
Thanks for your time.
Bookmarks