Compare two worksheets and Remove duplicated data from one

Solved/Closed
fillup56
Posts
3
Registration date
Sunday October 4, 2015
Status
Member
Last seen
October 6, 2015
- Oct 5, 2015 at 08:32 PM
fillup56
Posts
3
Registration date
Sunday October 4, 2015
Status
Member
Last seen
October 6, 2015
- Oct 6, 2015 at 10:11 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Oct 6, 2015 at 12:04 PM
You can try to use Match formula to and then use filter on #N/A to remove non matched items
2
Perfect - that worked - thanks very much.
0
fillup56
Posts
3
Registration date
Sunday October 4, 2015
Status
Member
Last seen
October 6, 2015

Oct 6, 2015 at 10:11 PM
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"
0