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$500 0=$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

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$500 0=$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.

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$500 0=$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.