Hi,

I have 2 columns of data. Column A has a list of names (text) - i.e Jack,
John, Pete, Greg. Column B has points (integer numbers) - i.e 1, 7, 1, 5.

I want to use a function that works out what the highest points in column B
is and then returns the corresponding name in column A.

Example:
Column A Column B
Jack 1
John 7
Pete 1
Greg 5

The answer to the function should return John because it is 1 column to the
left of the highest points from column A.

Can anyone help?

Steve