Function for 2nd and third low or Max
 

Hi all, as we all know, =Min() is looking for the lowest. =Max() is looking
for the highest.
Is there any command or way that can look for last 2nd or 3rd or up to 10th
please?
Say below ...
12
14
16
17
3
4
18
23
14
17
21

Min is 3.
Max is 23

How can I use Add-in or any command that that display 4 as next lowest, 12
as third lowest ....
Vice versa for Max ...
Max is 23. Second largest is 21 ...
Thanks

Function for 2nd and third low or Max
 

Check out the below functions

=LARGE(array,k)
=SMALLl(array,k)


If this post helps click Yes
---------------
Jacob Skaria


"Elton Law" wrote:

Hi all, as we all know, =Min() is looking for the lowest. =Max() is looking
for the highest.
Is there any command or way that can look for last 2nd or 3rd or up to 10th
please?
Say below ...
12
14
16
17
3
4
18
23
14
17
21

Min is 3.
Max is 23

How can I use Add-in or any command that that display 4 as next lowest, 12
as third lowest ....
Vice versa for Max ...
Max is 23. Second largest is 21 ...
Thanks

Function for 2nd and third low or Max
 

Tks ... Great job

"Jacob Skaria" wrote:

Check out the below functions

=LARGE(array,k)
=SMALLl(array,k)


If this post helps click Yes
---------------
Jacob Skaria


"Elton Law" wrote:

Hi all, as we all know, =Min() is looking for the lowest. =Max() is looking
for the highest.
Is there any command or way that can look for last 2nd or 3rd or up to 10th
please?
Say below ...
12
14
16
17
3
4
18
23
14
17
21

Min is 3.
Max is 23

How can I use Add-in or any command that that display 4 as next lowest, 12
as third lowest ....
Vice versa for Max ...
Max is 23. Second largest is 21 ...
Thanks