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

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.

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.