I have an Excel document that i need to filter some information from. The excel is setup like this.
A1 – Name
B1 – Phone Number
C1 – Email Address
The email address field is mixed with gmail, yahoo, hotmail, and personal domains. What i need to do is to be able to filter out based on domain. So my search parameter will be find email accounts gmail.com and copy all info from A1, B1 and C1 that match that line. I need to be able to do this on a list with 250 – 300,000 lines of data.
