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.
Bookmarks