How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have two spreadsheets. One with several rows containing contact

Customer Question

I have two spreadsheets. One with several rows containing contact details (sheet 1) and one with email addresses only (sheet 2).
I need to remove all the rows in sheet 1 which contain an email address from sheet 2.

Submitted: 3 years ago.
Category: Microsoft Office
Expert:  Jess M. replied 3 years ago.
Hi, welcome and thank you for your question. My name is Jess and I am glad to assist you today.

Can you send a sample copy of your Excel files? If it is possible, upload the files to and give me the 6-digit File ID or download link so that I can get your files.

Best regards,