Thread: How do I find the largest in a column

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" <gdubs@anywhere.net> wrote in message
news:W_6dnXTiid3hLV_eRVn-tQ@suscom.com...
> 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" <pashurst@auditel.net> wrote in message
news:1136835557.741841.65550@z14g2000cwz.googlegroups.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
>