Previous Topic Next Topic

Compare two worksheets and Remove duplicated data from one

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

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
fillup56
Oct 6, 2015 at 09:45 PM
Perfect - that worked - thanks very much.
0
fillup56 Posts 2 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

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
VBA Compare 2 sheets and output difference to 3rd sheet
jmah -
TrowaD -

3 responses
Macro to compare 2 sheets and copy differences
ehusar -
AirMaple -

2 responses
Ig stories from close friends to public
Darren -
zara -

31 responses