Bowling Spreadsheet: Top Scores

Hi All,

I'm building a spreadsheet for a bowling competition which has
the format :-

Name Game 1 Game 2 Game 3

Fred 143 165 183
Joe 161 142 130
Charlie 123 167 146

etc

If I use =MAX(cell range) I can find out what the highest score is but
how can I find out who has it and what if there is more than 1 person
with the same score ?

Thanks,

Jon

Have a look in HELP index for Rank

--
Don Guillett
SalesAid Software

"Jon" wrote in message
...
Hi All,

I'm building a spreadsheet for a bowling competition which has
the format :-

Name Game 1 Game 2 Game 3

Fred 143 165 183
Joe 161 142 130
Charlie 123 167 146

etc

If I use =MAX(cell range) I can find out what the highest score is but
how can I find out who has it and what if there is more than 1 person
with the same score ?

Thanks,

Jon

Jon,

I have a whole page on my web site related to rankings. See
www.cpearson.com/excel/rank.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jon" wrote in message
...
Hi All,

I'm building a spreadsheet for a bowling competition which has
the format :-

Name Game 1 Game 2 Game 3

Fred 143 165 183
Joe 161 142 130
Charlie 123 167 146

etc

If I use =MAX(cell range) I can find out what the highest score
is but
how can I find out who has it and what if there is more than 1
person
with the same score ?

Thanks,

Jon