Deleting rows which consists cell value PM and CM and remain cell value intact.

[aligahk06]

Dear All,


Can i delete all rows that consist cell value PM and CM.A column cell consist three kind of data PM,CM and RM.
I want to delete those rows which column value consist PM and CM only.




Rgds,
aligahk06

[mana]

You can use autofilter.