I am doing bowling scores. Each row contains a vowler's name and 3 game scores, all on the same row.
I use Max to find the highest score. This works like a champ. What I can't figure out, is how to also show the name with that high score. (The hame is located on the same row as the high score.,
I show the high score in a cell below the table, and that's where I would like to show the name that bowled that high score.
iMac 27″, macOS 11.6
I think I got the screenshots posted. That number to the left of the names is an overall average score The 3 numbers to the right of the names are the scores of the 3 games. As you can see, Betty Jean Johnson is the women't high score so far. So the 255 score for Women's High Game is 255. It would be nice if her name would appear next to that calculated (Max) score.
Make a column that has each persons high score. Take a look at the XLOOKUP function and search in that column. Note that it will only give one result, two if you use XLOOKUP twice (once to do a top down search and once to do a bottom up search). If you have several people with the same high score, it might be a problem if you want them all listed.
Yes### Success!!! Thank you for your expert advice. It took me a while to "break the code".
Can you post a screenshot? (shift-command-4, select area on screen with crosshairs, release, start new post here and insert the image using the 'mountain' icon beneath the compose window here).
SG
How to include a Name with result of MAX
