column query

  • Thread starter Thread starter Mat
  • Start date Start date
M

Mat

Greetings

I am trying to return a value in a column of a table based on a value in a
cell in the same row but different column.

For example, column A is a list of names, column B is a list of scores. In a
separate area i want to display the highest score with the name of the
person that achieved it. I've tried using MAX to display the highest score
but cannot think of a way to show who this value relates to in column A.

Does this make sense?

Many thanks for any help
 
Assuming:
col A = Names, col B = scores
data from row2 down

and there's *no ties* for the maximum score

If you have in say D1 : =MAX(B:B)

Try in E1: =OFFSET($A$1,MATCH(D1,B:B,0)-1,0)

E1 will return the Name in col A matching the highest score in D1
 
Back
Top