Hi. This seems like it should be simple but I'm not having any luck. If
column A is a list of names and B is a list of corresponding numbers (like
test scores), in C1 I want to find the highest score in B and show the name
of the person to whom it belongs. I can find the MAX in column B, but can't
seem to get beyond that.
Any help would be appreciated.