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

[Handyy]

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!

 

[Dave Peterson]

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

 

[Handyy]

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.