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

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
--
Regards,
Dave


"BigBuck98" wrote:

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

=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)

"BigBuck98" wrote in message
...
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

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



"BigBuck98" wrote:

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

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

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

Gordon

"Pete" wrote in message
ups.com...
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