How do I find the largest in a column

[BigBuck98]

I have a datebase containing 2 columns. In one column I have a persons name
in the other column is a number associated with that name. I would like to
search the column with numbers and find that largest number and the persons
name associated with that number and they place that name and number in
another cell. Example of names and numbers appear below. The answer can be
in one column or two.
Can this be done?
Thanks in advance,
Gordon

Smith, George 230
Henry, Bill 210
Thomas, Frank 200


Answer: Smith, George 230

 

[Guest]

Assume your names are in the range A1:A3 and the corresponding numbers are in
B1:B3.

In another cell (i.e. C1) put this formula:
=INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3,0))

In C2 put this formula:
=MAX(B1:B3)

Change the row/column references to fit your data

 

[Bob Phillips]

=MAX(B:B)

and

=INDEX(A:A,MATCH(MAX(B:B),B:B),0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Assuming your numbers are in column A and names in column B...........

=VLOOKUP(MAX(A:A),A:B,2,FALSE)&" "&MAX(A:A)


Vaya con Dios,
Chuck, CABGx3

 

[Pete]

Gordon,

your question implies that there can only be one highest value - no
possibility of 2 or more people having the same highest value?

Pete

 

[BigBuck98]

Pete,
Yes, I guess there could be more than one.

Gordon