• 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.

Can the MAX function be modified......

MAX will display the largest number from a range of unique numbers.
But i also need to find the 2nd & 3rd largest number in the same range.
What xl function must i use ???
Just a wild guess......
Can the MAX function be circumvented to MAX -1 (to give the 2nd largest) and
(MAX -2) to give the 3rd largest number.
I've searched the world wide web but couldn't find a function that modifies
MAX to MAX -1 or MAX -2.
ThankS a load.
 
Hi James,

You can use =LARGE() function instead Max, you will get 1 or 2nd etc number in the range.

Example

1
2
3
4
=LARGE(A1:A4,2) = Result = 3

in above example the 2nd largest is 3.

Regards
Abdul Matheen
 
Back
Top