Excel List Compare Icon

Excel List Compare

Excel macro compares row equality of 2 lists based on 1 to 4 columns

Excel List CompareOverview

Editor: Useful Excel macro will compare rows in 2 lists of data based on 1 to 3 columns in each list. Creates a new Spreadsheet with matched rows from original 2 lists merged together on the same row and unmatched rows highlighted on separate rows.
As the 2 lists of data are merged into a one spreadsheet, the number of columns of the 2 lists together must not exceed the maximum number of columns Excel supports.
Tested on MS Office 97 - XP.

NEW

Fixed some bugs.

Excel List CompareInformation

Version
1
Date
12.29.08
License
Free
Language
English
File Size
48KB
Developer
Category
SubCategory
Operating Systems
Windows XP, 2000, 98, NT
System Requirements
No additional system requirements.
TimeClick Icon
Quickly capture project time with the click of a mouse button
Free
More
Office Excel 2007 Icon
You can get specific information about this update in Microsoft Knowledge Base.
Demo
Kutools for Excel Icon
Bring more than 120 advanced functions to Excel.
Demo
Excell Icon
Manage your data by using CSV files
Free
NodeXL Icon
NodeXL is an Excel 2007 template for viewing and analyzing network graphs.
Free
Microsoft Excel Viewer 2003 Icon
open, view, and print Excel workbooks, even if you have example excel formula.
Free
Excel Macro Processor Icon
Apply MS Excel macros to a lot of xls files at a time with this automation tool.
Trial
Bond Portfolio Spreadsheet Icon
A Comprehensive Bond Portfolio Tracking Spreadsheet
Free
XLRISK Icon
Monte Carlo simulation software that makes quantitative risk analysis intuitive.
Trial
More