How do I find the highest number(s) in a column?

Giganews Newsgroups
Subject: How do I find the highest number(s) in a column?
Posted by:  BigBuck98 (gdu…@anywhere.net)
Date: Tue, 16 Jan 2007

I have a datebase containing 2 columns. In one column I have 105 individuals
names  in the other column is a number associated with each name. I would
like to  search the column with numbers and find the highest number and the
person(s)  name associated with that number and then place the name(s) and
number in
another cell. There could be more than one name with the highest number.
Example of names and numbers appear below.

I have been using the following formula, but I find there are times when
more than two individuals have the same number and then it only print the
first name that it comes to.

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

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

Is there a way to do this?
Thanks in advance,
Gordon

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

Replies