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?
for a range A1:a4. If you array enter correctly the formula will look like this