How to select top six numbers from a of range of random numbers

J

Jack M Taylor

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?
 
R

Ron Coderre

Try something like this:

With
A2: (player name)
B2:BA2 contains the scores
and
BB1:BG1 contains the series 1 through 6

Then
This formula returns the highest score for the player on Row_2
BB2: =IF(COUNT($B$2:$BA$2)>BB$1,LARGE($B$2:$BA$2,BB$1),"n/a")
Copy that formula across through BG2

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
R

Ron Coderre

Actually, the formula should be:
BB2: BB2: =IF(COUNT($B$2:$BA$2)>=BB$1,LARGE($B$2:$BA$2,BB$1),"n/a")

The ">" should be ">="

***********
Regards,
Ron

XL2002, WinXP
 
J

Jack M Taylor

Thanks Ron. Your solution worked a treat.

Ron Coderre said:
Actually, the formula should be:
BB2: BB2: =IF(COUNT($B$2:$BA$2)>=BB$1,LARGE($B$2:$BA$2,BB$1),"n/a")

The ">" should be ">="

***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top