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
fillup56 Posts 2 Registration date Sunday October 4, 2015 Status Member Last seen October 6, 2015 - Oct 6, 2015 at 10:11 PM
Related:
- Compare two worksheets and Remove duplicated data from one
- Transfer data from one excel worksheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Beyond compare - Download - File management
- How to remove number from blacklist - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 6, 2015 at 12:04 PM
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
Oct 6, 2015 at 09:45 PM
Oct 6, 2015 at 10:11 PM
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"