Excel List Compare v.1

Advertisement
Advertisement

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 macro compares row equality of 2 lists. This 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 seperate rows.

macro, compare lists, excel

 
  • Excel List Compare
  • 1
  • PSP Software
  • Win 3.1x, Win95, Win98, WinME, WinNT 3.x, WinNT 4.x, Windows2000, WinXP, Windows2003
  •  
  • Freeware
  • 48 Kb
  • 979
  • Free
 
 

Review Excel List Compare

  • captcha
 
 
New Spreadsheets software
  • XLSTAT  v.2018.7XLSTAT is a complete data analysis and statistics add-in for Excel. It includes regression (linear, logistic, nonlinear), multivariate data analysis, parametric tests, non parametric tests, ANOVA, ANCOVA, forecasting methods.
  • ExcelPipe Find and Replace for Excel  v.7.8Batch Search and Replace multiple Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses, phone numbers, data sources, translate with find/replace lists. Automatically handles passwords ...
  • DataNumen Excel Repair  v.2.3DataNumen Excel Repair is a powerful tool to repair corrupt Excel xls and xlsx files. It can scan the corrupt Excel files and recover your data in them as much as possible, so to minimize the loss in file corruption.