We have about 700 computers and are currently upgrading them all to IE8.
An asset number will be e.g. D111222 for a desktop PC & L111333 for a Laptop.
Some computers have already been upgraded but most have not.
I have 2 sample columns in the attached spreadsheet and need to know how I can merge the data and remove duplicates.
Column 1 are the computers already upgraded and column 2 contains computers requiring the upgrade, however, I know that column 2 has some duplicates of column 1