I run several competitions and end up with a list of name, score, rank. I use conditional formatting to highlight 1st, 2nd etc in the list and this works for ties. What I would like to do is to display on an other worksheet the highest 3 scores & names. I have used INDEX & MATCH to do this =INDEX($B$3:$B$100,MATCH(1,$D$3:$D$00,FALSE),1) but this will obviously not handle ties.
Help.........
Help.........