home page
Questions? E-mail us or call us 302-584-1771, 8AM to 10PM U.S. East Coast Time 7 days a week

View Cart

US $19.95

Add to shopping cart


Money back

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 2010-2021 and Office 365.

The Compare Columns Assistant can compare columns in a list or columns between lists.  The following illustrates comparing two lists to find the entries in the first list that are not in the second list:

Before       After
The Compare Columns Assistant can:
  • Compare lists that are in different worksheets or in different workbooks - Lists do not have to be in the same worksheet or workbook
  • Lists do not have to be sorted!
  • Identify entries that are either in both lists or are in one list and not in the other
  • Compare data in rows you have already matched up to see what is the same or what is different. 
  • Color, copy or insert an entry in a column when a matching (or non-matching) entry is found.
  • Delete entries when a matching (or non-matching) entry is found versus coloring or marking

The following illustrates comparing data from two months to find differences.  This comparison is a row by row comparison.

In the above, if the values go up for a part number, they are colored green. If they go do down,they are colored red.  If the text is difference, like "each" versus "box", the text is colored yellow. New entreis or missing entries are colored magenta.

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

Add to shopping cart

  US $19.95

Customers who viewed the Compare Columns Assistant also viewed:

Copyright 2024 LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of LLC.