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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks