ignore blank cells

L

Leticia

Hello,

Im using the formula MIN to select the minimun date of a columm, but in that
colum there are several blank cells that must keep blank. Which formula could
i use to ignore the blank cells ans selecct the minimun date?

Thank u!!!!

Leticia
 
D

Dave Peterson

=min()

it ignores text and empty cells.

or maybe:

=if(count(a1:a10)=0,"No Numbers",min(a1:a10))
 
A

Andy

I used this formula and it works great

{=min(if((a1:a10)>0,(a1:a10)))}

Notice though it is an array formula
 
D

Dave Peterson

Since the OP is working with dates, I bet all of the dates are positive <bg>.

Seems like overkill to me.
 
Top