Version: 1
Size:
48KB
Requirements:
MS Excel 97 or higher
MS Excel 97 or higher
Price:
Free
Free
System:
Windows XP/2000/98/NT
Windows XP/2000/98/NT
Rating:
4.4
4.4
License:
Freeware
Freeware
Description - Excel List Compare
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.