Text from Max value

S

Steve Jackson

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
 
A

Aladin Akyurek

See my post in:

http://tinyurl.com/562xz

Steve said:
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
Click to expand...

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.
 
Top