I'm trying to create a formula to tell me which rows to delete based data in
3 differnt columns. The following is an example with column D as the results.

A B C D
1 6/17/2008 ANN NO DEL
2 6/18/2008 BEE YES DONT DEL
3 6/19/2008 CEE NO DEL
4 6/17/2008 ANN NO DEL
5 6/19/2008 CEE NO DEL
6 6/17/2008 ANN DONT DEL
7 6/18/2008 BEE NO DONT DEL
8 6/18/2008 CEE DONT DEL

This the formula but it not giving the correct results:

=IF(SUMPRODUCT(($A$2:$A$5000<=$F$2)*1,($L$2:$L$5000=$L$2)*1,($J$2:$J$5000<>"")*1)>1,"Del","No Del")

Can someone help me get the correct results in column D please?
--
Cue

Thank you!
--
Cue


"MyVeryOwnSelf" wrote:

> > I'm trying to create a formula to tell me which rows to delete based
> > data in 3 differnt columns. The following is an example with column D
> > as the results.
> >
> > A B C D
> > 1 6/17/2008 ANN NO DEL
> > 2 6/18/2008 BEE YES DONT DEL
> > 3 6/19/2008 CEE NO DEL
> > 4 6/17/2008 ANN NO DEL
> > 5 6/19/2008 CEE NO DEL
> > 6 6/17/2008 ANN DONT DEL
> > 7 6/18/2008 BEE NO DONT DEL
> > 8 6/18/2008 CEE DONT DEL
> >
> > This the formula but it not giving the correct results:
> >
> > =IF(SUMPRODUCT(($A$2:$A$5000<=$F$2)*1,($L$2:$L$5000=$L$2)*1,($J$2:$J$50
> > 00<>"")*1)>1,"Del","No Del")
>
> I'm kind of guessing what the "correct results" are supposed to be. Maybe
> what follows would help getting started.
>
> In D1 put something like this
> =IF(AND(A1<=TODAY(),B1="BEE",C1<>""),"Del","No Del")
> Then extend down for as many rows as needed.
>