troubleshooting Question

Remove duplicates between 2 columns of data in Excel 2003

Avatar of auraorange
auraorangeFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Excel
3 Comments1 Solution229 ViewsLast Modified:
Hi,

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
Match.xls
ASKER CERTIFIED SOLUTION
Ardhendu Sarangi
Release Train Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros