Excel - Remove dupes and orignal
- or -
Post a project like this4055
£20(approx. $25)
- Posted:
- Proposals: 5
- Remote
- #223321
- Awarded
Description
Experience Level: Entry
I have 2 files.
File 1 contains 27,000 email addresses and first names
File 2 contains 4,000 dead email addresses (no names)
I want file 2 removed from file 1.
Please note file 2 does not have the names - I need these deleting as well from file 1 as well
EXAMPLE
File 1:
Name: Email Address:
David David@david.com
Paul Paul@paul.com
Heidi Heidi@Heidi.com
Rachel Rachel@Rachel.com
File 2:
Email Address:
Paul@Paul.com
Rachel@Rachel.com
Your work to look like this...
Name: Email Address:
David David@david.com
Heidi Heidi@Heidi.com
FINALLY
I want you to provide me with a step by step guide on how to do this, so I can do it for myself in the future.
File 1 contains 27,000 email addresses and first names
File 2 contains 4,000 dead email addresses (no names)
I want file 2 removed from file 1.
Please note file 2 does not have the names - I need these deleting as well from file 1 as well
EXAMPLE
File 1:
Name: Email Address:
David David@david.com
Paul Paul@paul.com
Heidi Heidi@Heidi.com
Rachel Rachel@Rachel.com
File 2:
Email Address:
Paul@Paul.com
Rachel@Rachel.com
Your work to look like this...
Name: Email Address:
David David@david.com
Heidi Heidi@Heidi.com
FINALLY
I want you to provide me with a step by step guide on how to do this, so I can do it for myself in the future.
David P.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
14%
Last project
25 Sep 2016
France
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies