|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
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:
In C2 put this formula:
Is there a way to do this?
Thanks in advance,
Smith, George 230
Henry, Bill 210
Thomas, Frank 200
Doe, Richard 230