Use the min-function to get the highest value of the three.
Then a nested if: if it's Barry's then it's Barry, else if it's Frankie's then it's Frankie, else it's Johnny.
Very doable with 3, even 4 or 5. But not the right solution with 10 or 20. Then use a vlookup-function in a table you make for this purpose.
Note that all solutions fail if 2 of the 3 have the same average.
Hope this helps.
I am making a spreadsheet to keep golf scores for me and two of my freinds. I have average scores for each player, what I want to do is on a summary page look at the averages for hole 1 find out which player has the lowest average and have his name appear on the cell.
if there is only two players I can do this using =IF(O12<O55,"Barry","Frankie")
But I just can't work out how to do this for 3 cells.