Forum Discussion

Copper Contributor

Nov 30, 2018

Filtering desired domains email address

Hi All, Thanks in advance for helping me out. I have a situation where I have a column of domains which maybe around 500 & I have another column which has around 58k email addresses. Now, what the i...

Copper Contributor

Dec 10, 2018

HI Amairah,

Thanks for the reply, what I am looking for is the list where email address matches the domains and those to be filtered out and not the count of how many are actually existing.

Haytham Amairah

Silver Contributor

Dec 10, 2018

Hi,

You can use the Advanced Filter as below screenshot:

Please note that the header of the List Range and the Criteria Range should be the same.

To learn more about the Advanced Filter, please see my reply on this similar question.

As the screenshot above, you need to surround each domain name with an asterisk character.

But since you have almost 500 names, I think you want a formula to automate this task.

So, I suggest using this formula:

=REPLACE(REPLACE(A1,1,0,"*"),LEN(A1)+2,0,"*")

Hope that helps