Minimum Number

[nnmmss]

My Range in sheet is A1:M1. I have different numbers in these cell
Positive , Negative, and Zero. I want to show the minium of number i
Range B1:M1 in A1 if that number is not zero.
i mean if these are my number 10,3,0,28,2.4 the minium of thes
range of number shows me 2.4 not zero.
how can i use formulan for this function.

Thank yo

 

[Norman Harker]

Hi "nnmmss"

A non-array way (assuming no neg. numbers in range):

=SMALL(A22,COUNTIF(A22,0)+1)

With negative numbers:

=SMALL(A22,COUNTIF(A22,"<=0")+1)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Peo Sjoblom]

One way

=SMALL(A1:M1,COUNTIF(A1:M1,0)+1)