minimum value excluding zero
 

i have a colourm with values ranging from 0 to 100, i want to find the
minimum value excluding 0

for example, if the row contains 100, 50, 30, 10, 0

the min value shown should be 10

the values are all postive values

thanx

minimum value excluding zero
 

Check your other post.

mkh wrote:

i have a colourm with values ranging from 0 to 100, i want to find the
minimum value excluding 0

for example, if the row contains 100, 50, 30, 10, 0

the min value shown should be 10

the values are all postive values

thanx

--

Dave Peterson

minimum value excluding zero
 

Hi,

Try this

=MIN(IF(A1:A5<0,A1:A5))

Eneter with Ctrl+Shift+Enter

Mike

"mkh" wrote:

i have a colourm with values ranging from 0 to 100, i want to find the
minimum value excluding 0

for example, if the row contains 100, 50, 30, 10, 0

the min value shown should be 10

the values are all postive values

thanx

minimum value excluding zero
 

I missed they were all positive so you can use this

=MIN(IF(A1:A50,A1:A5))

Once again array entered

Mike

"mkh" wrote:

i have a colourm with values ranging from 0 to 100, i want to find the
minimum value excluding 0

for example, if the row contains 100, 50, 30, 10, 0

the min value shown should be 10

the values are all postive values

thanx

minimum value excluding zero
 

This is one way
=SMALL(A1:A5,COUNTIF($A$1:$A$5,0)+1)

"mkh" wrote:

i have a colourm with values ranging from 0 to 100, i want to find the
minimum value excluding 0

for example, if the row contains 100, 50, 30, 10, 0

the min value shown should be 10

the values are all postive values

thanx