|
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. Excel List Compare is a freeware categorized under microsoft office tools.
Keywords: spreadsheet excel macro ms office 97 maximum number ms office 2000 space analysis
|
