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 réponses

Réponse 1 / 3
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
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