• 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


  • 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


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


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.