array enter (that is, hit enter while control and shift are depressed)On 2002-10-11 10:09, karini4 wrote:

I have been trying to enter a formula to find the lowest value in a range, but I want to exclude 0's. I haven't been able to figure it out. Any suggestions?

=MIN(IF(A1:A4,A1:A4))

for a range A1:a4. If you array enter correctly the formula will look like this

{=MIN(IF(A1:A4,A1:A4))}

good luck

## Like this thread? Share it with others