Home/ Questions/Q 10537
Next
Answered
computing
  • 1
Asked: 2021-12-06T01:54:54+00:00 In:

Find Top 3 Values And Return Names

  • 1

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.

Share

    1 Answer

    1. Best Answer
      Hi,

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

      Then 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 score

      In 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

      • 0