Compare two worksheets and Remove duplicated data from one [Solved/Closed]

Report
Posts
3
Registration date
Sunday October 4, 2015
Status
Member
Last seen
October 6, 2015
-
Posts
3
Registration date
Sunday October 4, 2015
Status
Member
Last seen
October 6, 2015
-
Hello everyone,
I am struggling to find a solution and would value input from fellow users.
The Problem:
I have two separate worksheets "Customers" & "Members".
Some customers are also members.
I want to remove all Customers from the Members sheet.
The only common field is email address.

Thank you in advance for your assistance - it is greatly appreciated
Kind regards

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
You can try to use Match formula to and then use filter on #N/A to remove non matched items
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Perfect - that worked - thanks very much.
Posts
3
Registration date
Sunday October 4, 2015
Status
Member
Last seen
October 6, 2015

Dear VIZVISA1
I followed your suggestion. Then copied the resultes to a new worksheet called "Customers Minus Members" Sorted for those with Numbers and N/A then deleted those with Numbers leaving only the N/A
I just could not see the solution - thank you for "opening my eyes"

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!