Getting the 2nd largest or smallest valuesin a range

  • Thread starter Thread starter Michael Rekas
  • Start date Start date
M

Michael Rekas

Hi there

Th MAX & MIN functions return the largest & the smallest values in a
range.

Is there a way to get the 2nd largest and smallest values?

Any help appreciated.

Thanks

Michael
 
Thanks

I have combined with countif "=0"+1 to ignore zero values in the
range.

Much appreciated

Michael
 
=SMALL(IF(A1:A100,A1:A100),2) array entered using CTRL+SHIFT+ENTER will
ignore 0s and blanks
 

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

Similar Threads

smallest to largest 9
rank of text instead of numbers 1
Cannot sort data 6
First Value in Sorted Column is Not Sorted Properly 3
Can I calculate a statistical range (largest minus smallest)? 2
Any function to determine the smallest common factor from a list? 4
SMALL IF 4
SMALL FUNCTION - How it works 6

Back
Top