I'm not really sure how best to describe this. I am trying to allocate scores to different classes on an athletics record sheet. Their times are already written in rank order, but I need the scores to fill in automatically.
I think I need to use a combination of =rank, =index, =match, taken from raw data elsewhere, and I have used these functions independently, but am getting stuck on how to combine them.
So looking at the attachment, if 10.6 finish first, 7 points should appear in their total box at the end of the row.
The formula needs to utilise the rank function in case two scores are the same simultaneously and the points need to be shared. I have used this function before but not to this complicated degree!
Please help! Thanks
athletics sheet example.xlsx
Bookmarks