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

[James Perry]

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.

 

[Abdul Matheen]

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

 

[Syedali]

Wow Super Mr Abdul.

 

[James Perry]

Thank u Mr. Abdul.I'll stick to LARGE.