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

=min()

it ignores text and empty cells.

or maybe:

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



Leticia wrote:

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

--

Dave Peterson

I used this formula and it works great

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

Notice though it is an array formula

"Dave Peterson" wrote:

=min()

it ignores text and empty cells.

or maybe:

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



Leticia wrote:

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

--

Dave Peterson

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

Seems like overkill to me.

Andy wrote:

I used this formula and it works great

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

Notice though it is an array formula

"Dave Peterson" wrote:

=min()

it ignores text and empty cells.

or maybe:

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



Leticia wrote:

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

--

Dave Peterson


--

Dave Peterson