Excel List Compare
PSP Software
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 in microsoft office software.
Price: Freeware
Version: 1 Released: 12/1/2004
Size: 0.05 MB
Platform: Win 3.1x, Windows 95, 98, ME, NT 3.x, NT 4.x, Windows 2000, XP, Windows 2003
Download Link: Download
Keywords: excel equality row columns compares based macro lists compare lists
|
|