Oct 22 2021 10:50 AM
I have two columns, column A with domain names (around 500), column B with email addresses (around 5000) - how can I identify email addresses that contain the domains?
For example, if my list of domains is:
yahoo.com
nike.com
adidas.com
I need to identify email addresses that contain: @yahoo.com, @nike.com / @adidas.com
Thank you!
Oct 22 2021 11:30 AM
I suggest conditional formatting to identify all email addresses for a certain domain. I entered data validation for all domains (3 in this example) in A1 and chose "adidas.com" and all email addresses containing "@adidas.com" in column B are highlighted.
I entered this formula (rule) for conditional formatting;
=COUNT(FIND("@"&$A$1,B1))
and in the manager for conditional formatting, in the field "applies to" i entered:
=$B$1:$B$1000
This can be adjusted to the requirements.
Oct 25 2021 10:16 AM