Bowling Spreadsheet: Top Scores

  • Thread starter Thread starter Jon
  • Start date Start date
J

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
 
Back
Top