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 767
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