5 highest values formula

[Belleke]

I have this formula in one cell

=INDEX(C2:C411,MATCH(MAX(P2:P411),P2:P411,0))

What would be the formulas to display the five highest scores in five cells.
The names are in column C, scores are in column P
There can be identical scores.
Thanks

 

[NARAYANK991]

Hi ,

Use the LARGE function to return the largest , second largest , third largest ,... values in a range.

=LARGE(P2: P411 , 1) is equivalent to =MAX(P2: P411)

=LARGE(P2: P411 , 2) will return the second highest value in the range.

=LARGE(P2: P411 , 3) will return the third highest value in the range.

Narayan

 

[Belleke]

Thanks