Hello,
I have a large email list, I have attached an example. From the email list I have separated the address prefix and the domain suffix with the delimit function.
[email protected] = lol and gmail.com in separate columns, but on the same row.
Many of the emails have useless addresses, for example: info, wineclub, etc. I would like to filter my list such that these useless address prefixes exclude the email from the table.
I have tried using the <>info and <>wineclub commands, but every time I try to filter with multiple <> criteria, excel fails to filter any of the data.
Have I structured my logic wrong? What is wrong?
Sonoma_Test1.xlsx
Please help.
Bookmarks