If/Then statement, delete if value = x

[ChrisS92]

Hello,

I have a particular set of data:

AA
BB
AB
CC
CA
CD
DA
FA
FD
FC

I want to create an if/then statement to delete all values that contain either an "A" or a "D" for purposes of eliminating irrelevant data. What would my statement look like?

Thanks in advance!

 

[bbott]

You can't do that with a formula. You may be able to use conditional formatting and then filter by color. Otherwise, I think you'll need a VBA solution.