Thomas
asked on
Compare 2 sheets and identify data
Hi,
I have a little issue in Excel and hope someone has a pointer for me.
Basically, I have a customer database that has names, emails, etc. secondly I have a second excel that only has emails in of customers that opted out. What I try to do is to either compare the 2 and identify the cells that are in the customer list where the email cell matches the email in the "op out" file.
I would appreciate any assistance on this.
Best wishes,
Thomas
I have a little issue in Excel and hope someone has a pointer for me.
Basically, I have a customer database that has names, emails, etc. secondly I have a second excel that only has emails in of customers that opted out. What I try to do is to either compare the 2 and identify the cells that are in the customer list where the email cell matches the email in the "op out" file.
I would appreciate any assistance on this.
Best wishes,
Thomas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Confirmed by aithor in subsequent comment
ASKER
Thank you for the assistance, it worked fine.