Find Top 3 Values and Return Names

August 20, 2010 at 12:01:33
Specs: Windows XP

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.

See More: Find Top 3 Values and Return Names

Report •

August 20, 2010 at 16:06:10

If you have names in cells A2 to A9
Scores in cells B2 to B9

Then enter this in cell D2:
This will return the name of the person with the highest score

In D3 enter:

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:

In E3 use:

Adjust ranges to match your data

Hope this helps.


Report •

March 3, 2011 at 18:23:32
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)?

Report •

Related Solutions

Ask Question