Displaying "top 3" from a column

[Tony C]

Hello -

Is there a forumula I can use that will search a column for the top 3 and list them elsewhere?

Please see example below:

Please note that the #3 rank has a tie for 3rd place, so it would need to bring both values over (Amy and Paul).

Once again, appreciate you all sharing your expertise!

 

[NARAYANK991]

Hi Tony ,

Check this file.

Narayan

 

[Tony C]

Hi Tony ,

Check this file.

Narayan

Thank you Narayan.

That's really close to what I'm looking to do, but that is returning every instance of the top 3 single values not considering duplicate values.

In other words, it realizes that the top 3 values are 8,7, and 6 not considering that there are 3 values that = 8.

In other words:

• If there were values of 8,8,7,6,5 I would want it to return only the people that have 8, 8, and 7 because the top twp people would be tied at 8 giving them each a rank of #1 making the person with 8 ranked #3.
• If there were values of 8,8,7,7,6 I would want it to return only the people have have 8,8,7, and 7... because their ranks would be 1,1,3,3 respectively.

I would want to stop returning values for anything ranked higher than 4.

​

 

[NARAYANK991]

Hi Tony ,

Let me understand your logic ; if we have a list consisting of 8,8,8,8,8,8,7,7,7,7,7,... , only the six 8s would be returned.

If the list consists of 8,7,7,7,7,7,7,7,6,... , what would be returned is 8,7,7,7,7,7,7,7

Narayan

 

[NARAYANK991]

Hi Tony ,

Check this file.

Narayan