Hello,
I have 2 lists of data. They are sku numbers for parts. One list is our master list which has about 60,000 items in it. The second list is what I need to remove from the master list, which is about 800 items. Is there an automated way to remove these 800 items in the second list from the master list?
Thanks and Best Regards,
Damian
In the master list add a formula in an available column like this:
=Isnumber(Match(A1,Sheet2!$A$1:$A$800,0)) and copy down
where A1 contains first part in the 60000 item list and Sheet2!A1:A800 contains the 800 item list.
Then filter this list Through Data|Filter|Autofilter and choose TRUE in that formula column
Then select all the rows that are filtered and delete the rows... now unfilter and you should have all items with FALSE in the formula column... you can then delete that column, if desired.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks