Add-ins.com home page
Microsoft Office Marketplace logo
Questions? E-mail us or call us 302-234-9857, 8AM to 10PM U.S. East Coast Time 7 days a week
 

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

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 and Excel 2010.

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:

compare lists in Microsoft Excel

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:

actions to take if matches found between two lists

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!

Add to shopping cart

  US $49.95



Customers who viewed the Compare List Assistant also viewed:

 
       

View Cart

US $49.95

Add to shopping cart

Qty
Discount
2
10%
3
20%
4
30%
5-9
40%
10 or
more
50%

Order online.
Get delivery
in minutes!

Order Risk Free
Money back
guarantee
if not satisfied.
Recently Viewed



Home * About * Contact * Feedback * Upgrades * Money Back Guarantee * FAQ's
Download Information * Ordering Questions * Support
Product List * New Products * Free Products * Trial Versions * Products by Others

Copyright 2011 Add-ins.com LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of Add-ins.com LLC.
Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.