View original (French)

Create a podium

Solved
All3yez -  
 All3yez -
Hello,

I need your help to create a formula that will display a top 3.

Here’s an example:

In A1;A11 I have names.
In B1;B11 I have the points corresponding to the names.

The goal is to display the 3 "best names" in cells A13, A14, and A15.

I tried using the LARGE function, but it only shows the points and not the names.

Sorry, it might be simple but I haven’t found a solution... Thank you for your help.

Best regards.

Configuration: iPhone / Safari 9.0

3 answers

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Hello.

    In A13, formula
    =INDEX($A$1:$B$11, MATCH(LARGE($B$1:$B$11, 1), $B$1:$B$11, 0), 1)

    Retirement is great! Especially in the Caribbean... :-)
    Raymond (INSA, AFPA, CF/R)
    1