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