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
Related:

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

Can't remove threat with Windows Defender
Babarali4 -
ravida_1351 -

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

31 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses