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
 

You can use this array formula:

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

Type it in and enter it by pressing Ctrl+Shift+Enter.

Cheers,
Jason Lepack

On Apr 7, 9:06 am, 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
 

Check your other posts, too.

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