Automatically Filter Out Row Based on Cell Value

[shaebert]

Hello,

I have a spreadsheet that is connected to an automated application (Zapier).

Every time someone registers for one of our events, a new row is created in the table of a spreadsheet. However, I want to hide anyone who registers from our company (anyone with "smith[DOT]com" in their email domain for example). I can do this easily by enabling filtering on the table/column and select "Does not contain: smith[DOT]com." However, I don't want to have to manually do this every time someone from my company registered. I want the table to automatically filter out a row if the domain in their email address contains "smith[DOT]com." How could I accomplish this in excel?

See attached workbook.

[LeoTaxi]

By saving or closing the workbook

Please Login or Register  to view this content.

Kind regards
Leo

[bebo021999]

Creat an Outcome table from column H

H2:

Please Login or Register  to view this content.