Apologies for the awful title, I couldn't think of how to describe the problem.
In the attached spreadsheet, I have a data set and then 4 'results' boxes (entitled with what they should include).
For example, H6 should return the name/value B3 'Paul Murrin' as the quickest male. Likewise, L6 should also return the same name as the male with the largest %. And so on for the female results boxes.
I can't quite think how to proceed or even what functions to use.
Many thanks in advance.
Bookmarks