Compare Lists Assistant An add-in product for Microsoft Excel Align and compare lists Find entries in one list that are in another Find entries in one list that are NOT in another Compare ranges and highlight differences Easy to learn with the help and exercise file Download a trial version now!

The Compare Lists Assistant add-in for Microsoft Excel will quickly and easily align and compare two lists or worksheets.  It is compatible with Microsoft Excel 2003, Excel 2007, Excel 2010 and Excel 2013. It will identify new and deleted rows and any cells whose values have changed.  Or you can use the Compare Lists Assistant to compare two lists and have it color or copy the rows which are in both lists (or the rows which are not) to a new worksheet. The report to the right is the result of comparing two lists on separate worksheets.  Green rows are new rows in the new list.  Red rows are rows that have been deleted in the on the older list. Gold cells are cells whose values or entries have changed.  Comments are added by the Compare Lists Assistant to show the value of the cell in the old list. Comments are optional. To see a larger image, click on the report.

The main dialog of the Compare Lists Assistant looks like the following:

To learn how to use the Compare Lists Assistant, just click on the the "How to use" button.  This will open a help and exercise file with step by step instructions. 

If you choose the main dialog option to find entries in one list that are in a second, the following dialog appears:

This gives you the option to color, copy, delete or put a marking cell entry in a column of your choice if matches are found. 

If you select the option on main dialog to find rows in a list that are not in another list, then the same options are presented and allow you to color, copy, or delete the rows in the first list that are not in the second list.

Customers who viewed the Compare List Assistant also viewed:

• Productivity Suite - Contains all of our add-ins including the Compare List Assistant.  Save $$
• Address Assistant - Easily split addresses in one cell into multiple cells. Fix zip codes needing leading zeros.
• CSV File Creator - Create CSV files the easy way, without Excel's warning messages.
• Data Cleaner - Eliminate tedious manual cleaning of data
• Duplicate Finder & Deleter - Quickly find and remove duplicates in one list or between two lists.
• Text File Importer - Import ASCII or text files with over a million lines!