# Find Top 3 Values and Return Names

August 20, 2010 at 12:01:33
Specs: Windows XP
 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.

See More: Find Top 3 Values and Return Names

#1
August 20, 2010 at 16:06:10
 Hi,If you have names in cells A2 to A9Scores 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 dataHope this helps.Regards

Report •

#2
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