Compare Columns Assistant An add-in product for Microsoft Excel Compare columns between lists Compare columns in a list Color differences if both in the same list Copy differences from one list to the other      if comparing different lists Download a trial version now!

The Compare Columns Assistant add-in for Microsoft Excel makes comparing columns in Microsoft Excel worksheets very easy.   It is compatible with Microsoft Excel 2003, Excel 2007, Excel 2010 and Excel 2013.

The Compare Columns Assistant can compare columns in a list or columns between lists.  The main dialog gives the following options:

The selection of data is menu driven. One can select lists that are on the same worksheet, in different worksheets, or in different workbooks.  One can select just a single column in each list or multiple columns.  Once selected, one has the following options:

And, one can even have the Compare Columns Assistant copy the rows that are different to another worksheet:

Customers who viewed the Compare Columns Assistant also viewed:

• List Assistant - easily move cell ranges and rows around.