Delete Rows which match condition

[rizmomin]

Hello:

Please refer to attached fie.
I have a list of transaction as shown.
I need to delete all rows if there is character "S" in column D
Please let me know if you have any questions.
Thanks.

Riz

[Richard Buttrey]

Hi,

Apply an Autofilter and filter ColumnD with a Text Filter that contains "s"

Then select all the filtered rows and delete them.

[rizmomin]

Hi Richard:

That would works.
Thanks a lot
Riz