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 John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

Efficient way to do this in Excel? 1. Find rows within a

Resolved Question:

Efficient way to do this in Excel?

1. Find rows within a sheet which have duplicate values in a column (though perhaps their rows are different) and delete all but one of the duplicates.
2. Do the same but between two sheets in the same worksheet, deleting all of the rows on the second sheet which contain a duplicate value of the compared rows.

I have played with the duplicate function I found in excel, and it seems I can only highlight all duplicates, which leaves the large task of deleting out the duplicates since there are thousands. The function which deletes duplicates will not delete the entire row associated with the duplicate, which ends up making the table data screwy.

Submitted: 5 years ago.
Category: Microsoft Office
Expert:  John D replied 5 years ago.
Hello and welcome to JustAnswer. I look forward to assisting you today with your question and providing the best answer possible.



You will need a macro for that. I can write you a custom macro but you need to open a question in the Programming section and assign an appropriate value in line with the work involved.




Customer: replied 5 years ago.
Ok, what's an appropriate value? And how quickly will you finish?

Also, this macro will have to work for Office for Mac 2011.

Expert:  John D replied 5 years ago.

Dan, experts are not allowed to suggest amounts. Customers make offers and experts can either take the question or leave it


If you post it now I should be able to finish it within 20 mins




Customer: replied 5 years ago.
I posted it over in programming, thanks.
Expert:  John D replied 5 years ago.

yes I saw it



Customer: replied 5 years ago.
There is no accept button anywhere?
Expert:  John D replied 5 years ago.

Hi Don


Here you go





John D and 5 other Microsoft Office Specialists are ready to help you