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!
Bookmarks