Bowling Spreadsheet: Top Scores

[Jon]

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

 

[Don Guillett]

Have a look in HELP index for Rank

 

[Chip Pearson]

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