• Home
• Products
  Our Product List New Products Analysis Products Charting Products Data Products Downloadable Books Macro Products Specialty Products Time Saving Products Workbooks and Templates Products by Others Windows Products iPhone Applications
• Download
  Download Information Download Purchased Software Download Upgrades
• Support
  Support Top Support Questions Ordering FAQ's Money Back Guarantee Product FAQ's Online Meeting Excel Problems & Solutions How to Open and Use Excel add-ins How to repair Microsoft Excel
• Excel Solutions
  Charting Solutions Editing Solutions Formatting Solutions Formula Solutions Function Solutions Pivot Table Solutions Printing Solutions Selecting Solutions Toolbar and Menu Solutions Window Solutions Workbook Solutions Worksheet Solutions Other Solutions
• Company
  About Add-ins.com LLC How to contact us Contact Form Customer Feedback Policies License Agreement

Compare lists in Microsoft® Excel® with the
Compare Lists Assistant

The Compare Lists Assistant addin for Microsoft Excel will quickly and easily align and compare two lists or worksheets.  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 in Microsoft Excel.  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.

Order online from our secure service Get delivery in minutes! For Excel 97, 2000, 2002, XP, 2003, and 2007 Order Risk Free Money back guarantee if not satisfied   $49.95

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.  The following video illustrates the exercise of aligning and comparing two worksheets:

Flash video of aligning and comparing worksheets

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.

Order online from our secure service. Get delivery in minutes!

$49.95

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 - Quickly find and remove duplicates in one list or between two lists.
• Multi-Column Sorter - Sort up to ten columns at once!
• Text File Importer - Import ASCII or text files with over a million lines!