Delete Entire Row where there is text (word) in the Column

Hi All

I want to delete entire rows where a word is repeated down Column G. If Cells G1, G20, G100, etc. contains the word "GOV" I want to delete rows 1,20,100, etc.

Thanks

Patish

Try:

Please Login or Register  to view this content.

Many thanks, Olly. Worked like a charm.

Originally Posted by Patish

Many thanks, Olly. Worked like a charm.

Happy to help, thanks for the feedback.