Biggest value from B:B with Name from A:A

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Handyy - 19 Jul 2006 00:30 GMT

Is there an easy way doing this.

A B
1 Name1 7
2 Name2 8
3 Name3 5
4 Name4 3
5 Name3 3

I'm trying to find biggest value from column B but I also would like to
get the name from column A. So that I would end up with Name 1 - 7 into
another sheet. How can I get A column to get involved in this?

The sheet I'm using has data for 1500 lines having names on col A and
number on col B.

Thanks!

Signature

Handyy

Reply to this Message

Dave Peterson - 19 Jul 2006 01:24 GMT

=index(Sheet1!a:a,match(max(sheet1!b:b),sheet1!b:b,0))

> Is there an easy way doing this.
>
[quoted text clipped - 19 lines]
> Handyy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30958
> View this thread: http://www.excelforum.com/showthread.php?threadid=562680

Signature

Dave Peterson

Reply to this Message

Handyy - 21 Jul 2006 20:45 GMT

Hi,

Thanks for the answer, but I think I missed my point at my question,
I'm sorry about that.

What I actually want to do, is to get that list generated elsewhere in
descending order sorted by the B-column. So as for results, I would
want to print out 10 of the highest numbers and respective names beside
them in the A-column.

Signature

Handyy

Reply to this Message

Rate this thread: