Function for 2nd and third low or Max

[Elton Law]

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

 

[Jacob Skaria]

Check out the below functions

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


If this post helps click Yes

 

[Elton Law]

Tks ... Great job

Check out the below functions

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


If this post helps click Yes