min, max functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in trying to find a min value, how do i exclude zeros from the list to be
looked at?
 
if you are sure there are some zero values then use
=small(dataange,2)

if you are not sure then use Dmin. see help
 
Hi!

Array entered with the key combo of CTRL,SHIFT,ENTER:

=MIN(IF(A1:A100<>0,A1:A100))

Biff
 
That won't exclude zeroes. You can use SMALL but will still need to use
something like Biff's example, eg

=SMALL(IF(Rng<>0,Rng),1) array entered.

or

=SMALL(IF(Rng,Rng),1) array entered.
 
apologies to the newsgroup
=small(datarange,2)
will be ok only if there is only one zero
probably I was hasty.
I modified this to
=IF(MIN(A1:A13)=0,SMALL(A1:A13,COUNTIF(A1:A13,"0")+1),MIN(A1:A13))
but I found that others have since given more elegant
solutions.
 
You must log in or register to reply here.

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

Max and Min 4
How do I exclude the HIGH and LOW values in the =AVERAGE function 2
Help with time function 4
Min Function Excluding Zero Values & More 8
MAX() and MIN() 4
Making MAX and MIN range variable 1
Min excluding zero values, without an array fomrula 13
Min/Max of Numbers as Text 8

Back
Top