Hello all, I have a list of vendors (which includes employees) in worksheet 1. I have a list of only employees in worksheet 2. I am trying to highlight and remove all of the employees in sheet 2 from Sheet 1. Tried to highlight duplicates but a lot of my vendors are duplicates and thats ok. I just need to remove the people in sheet 2 from 1.
Vendors is Sheet 1- A1:A3814 and Employees is Sheet 2 A1:A869
You can remove duplicates from the list by using Excel 2010 feature Remove Duplicates located under Data tab on the ribbon.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
the problem with that is that it highlights duplicates within my column instead of comparing the two
Could you please upload a sample workbook with about 10-20 rows? That way we will have a better idea on how to approach your problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks