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
  • 963
  • Free
 
 

Review Excel List Compare

  • captcha
 
 
New Spreadsheets software
  • XLSTAT  v.2018.4XLSTAT 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.
  • 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.
  • Data Curve Fit Creator Add-in  v.2.70Adds data curve fitting, interpolation and data smoothing functions to Excel. Functions include polynomial fits, several types of splines, and local regressions. Filters include moving average, Gaussian smoothing and median filtering.
  • ExcelPipe Find and Replace for Excel  v.7.6Batch Search and Replace multiple Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses and phone numbers, translate with find/replace lists. Automatically handles passwords. Unicode compliant ...
  • MileCharter  v.2.12Calculate Mileage Charts and Tables with Microsoft MapPoint. Calc. tables for customers and suppliers incl. "closest only", or to create "road atlas" tables. Output Distances, travel times and/or estimated costs to Excel. Supports ALL route options.
  • After The End  v.1.5.0Cut your way through locations filled with mutants in this 3rd person 3D-shooter. Nice 3D graphics and sound FX, 16 weapons and devices, 3 game modes (Campaign, Firing range, survival), Worldwide Hall of Fame and much more.