I have a worksheet with the results of 52 golf matches throughout last year
for 50 players. I need to be able to show, for each player shown in column
A, the six highest scores achieved throughout the 52 weeks of the year (the
results for each players are entered in the 52 cells to the right of the
player's name). Some of the players have blanks in the cells when they did
not play or return a score. Is there a formula I can use such that each of
the top six results will appear in six separate columns in the corresponding
row for each player?