Attached workbook contains an example, where a formula in column returns TRUE when searched string is found in certain column (it looks like you can't start the search string with special character like "@", but mostly this is not needed).
You can set autofiler for column IsMatch, and e.g. delete filtered rows - or do whatever you want with them.
|