Excel - Remove dupes and orignal

  • Posted:
  • Proposals: 5
  • Remote
  • #223321
  • Awarded
Mark C.
John M.Rod R.SpecTronics UKJustCreative D. have already sent a proposal.
  • 1


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


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:

Your work to look like this...

Name: Email Address:
David David@david.com
Heidi Heidi@Heidi.com


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.

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.