Formula Help??

  • Thread starter Thread starter Erika
  • Start date Start date
E

Erika

Hi all,
I have something I need help with. I am trying to write
a formula that is making me crazy!!!

I have 3 columns in a spreadsheet that consist of a date,
a condition and a value.

Date Condition Value
1-20-03 AR 1
7-31-03 MF 5
6-01-03 MF 20

I want my formula to do this:
If the date is less than 60 days, and the condition is NOT
MF and the value is 20 or 1, then "retain" else "delete".
After the above is performed, I want to be able to sort
the file and delete anything that returned "delete"
because I don't need to look at those.
My problem is that I have probably 20 different values
that will need to be included in the formula. Is a
formula the way to go or should I create a macro? It
seems a macro would fit best since I want to delete
anything that says "delete".

Help on a formula or macro would be greatly appreciated.
I hope I have made sense :)

Thank you,
Erika
 
Try:

=IF(AND(A2>=TODAY()-30,B2<>"MR",OR(C2=
{1,20})),"retain","delete")

and fill down. Then do an autofilter and filter
for "delete" on the formula column.

HTH
Jason
Atlanta, GA
 
Back
Top