In the attached spreadsheet, I have a data set and then 4 'results' boxes (entitled with what they should include).
For example, the value in H6 should return the value in B3/name 'Paul Murrin' with the smallest time for men. In H7 it should be the next smallest time giving the result in B4 'Matt Stott'. Likewise in L6 it should be the value in B3, with the highest % for males.
I'm unsure how to proceed or even what functions to start with.
Thanks in advance.
Bookmarks