Function for 2nd and third low or Max


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
 
Ad

Advertisements

J

Jacob Skaria

Check out the below functions

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


If this post helps click Yes
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top