- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- How do I find the highest number(s) in a column?

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

- Re: How do I find the highest number(s) in a column? posted by T. Valko on Tue, 16 Jan 2007