Forum Discussion

PoorMens_Bravo's avatar
PoorMens_Bravo
Brass 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...
Excel
Excel on mobile
Excel Online
  • PoorMens_Bravo's avatar
    PoorMens_Bravo
    Brass 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's avatar
      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

Resources