• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

5 highest values formula

Belleke

Well-Known Member
I have this formula in one cell
Code:
=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

Excel Ninja
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
 
Top