|Posted by:||Mat (buffaloesi…@DELETE2REPLYhotmail.com)|
|Date:||Thu, 6 May 2004|
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