Function for 2nd and third low or Max

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

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
 
Check out the below functions

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


If this post helps click Yes
 
Back
Top