Delete Formula Based on Multiple Columns

C

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$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?
 
M

MyVeryOwnSelf

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.
 
C

Cue

Thank you!
--
Cue


MyVeryOwnSelf said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top