Compare 2 Sets of List Columns in Excel 2013
Posted on 2013-11-06
I have 2 sets of data, in this case a printer name and driver name. I got these from 2 different print servers. I need compare these 2 sets of data to determine which printer drivers don't match between the two servers.
I have 4 columns
1 print server data is columns A and B
the othe rprint server data is columns D and E
Column A - Printer Name
Column B - Driver Name
Column C - Printer Name
Column D - Driver Name
I would like to compare the data and indicate in column G, which printer drivers don't match between servers and the printer name.
I do not have the same number of printers and their drivers between columns A&B and C&D.
I know this can be done in Excel, just don't know how.