Hi, It's been a while since my last post but now I again need help. (i'm a hopeless wretch)

What I have is a data of 2 columns. Col A contains names and Col B contains numbers. There are no duplicate names. What I am trying to do is in Cell D1, return the names from column A who got the top 3 scores shown in column B.

To explain further, Is it possible to automatically look at the list under column B, get the top 3 highest numbers, then return the names in their row, under column A.

I appreciate the help in advance.

Hi, If you have names in cells A2 to A9

Scores in cells B2 to B9Then enter this in cell D2:

=OFFSET($A$2,MATCH(LARGE($B$2:$B$9,1),$B$2:$B$9,0)-1,0)

This will return the name of the person with the highest scoreIn D3 enter:

=OFFSET($A$2,MATCH(LARGE($B$2:$B$9,2),$B$2:$B$9,0)-1,0)The only difference is that this uses 2 in the LARGE formula, to find the second largest value and in-turn the name on the same row of the person with the second highest score.

To just get the scores in column E use this in E2:

=LARGE($B$2:$B$9,1)In E3 use:

=LARGE($B$2:$B$9,2)Adjust ranges to match your data

Hope this helps.

Regards

what if in B2 to B9, there are two same large numbers but from different names. example name-2 has 34 and name-4 has 34 also, and 34 is the largest number. How to show both name-2 and name-4 in the target cell(s)?

Ask Your Question

Weekly Poll

Do you think Jony Ive could make a big impact on Airbnb?

Discuss in The Lounge

Poll History