I have a weekly report that I have to run covering multiple machines in our environment. Once I've run it I have to update a risk register with the changes. I'm looking for a way to compare the two sheets and delete the duplicates that appear on the previous weeks sheet based off of two specific columns of data. In this case it is column B (Plugin ID) and column C (PC name). I'm wanting to delete the duplicate rows from my current sheet only if they match exactly column B & C exactly from the previous weeks sheet so that it only leaves me with the changes between weeks.
I've gone trough conditional formatting and I can get it to match on Column B & C so it will highlight duplicates from either column but not B&C together.
Example:
Week 1
Plugin ID A Machine name A
Plugin ID A Machine Name B
Plugin ID A Machine Name E
Week 2
Plugin ID A Machine Name A
Plugin ID A Machine Name B
Plugin ID A Machine Name E
Plugin ID A Machine Name X
I want to remove all duplicates so that week 2 only shows:
Plugin ID A Machine Name X
After being compared to week 1.
Bookmarks