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!


--
Handyy
------------------------------------------------------------------------
Handyy's Profile: http://www.excelforum.com/member.php...o&userid=30958
View this thread: http://www.excelforum.com/showthread...hreadid=562680

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



Handyy wrote:
>
> 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!
>
> --
> Handyy
> ------------------------------------------------------------------------
> Handyy's Profile: http://www.excelforum.com/member.php...o&userid=30958
> View this thread: http://www.excelforum.com/showthread...hreadid=562680

--

Dave Peterson

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.


--
Handyy
------------------------------------------------------------------------
Handyy's Profile: http://www.excelforum.com/member.php...o&userid=30958
View this thread: http://www.excelforum.com/showthread...hreadid=562680