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

Review Excel List Compare

  • captcha
 
 
New Spreadsheets software
  • XLSTAT  v.2019.2.3XLSTAT 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.
  • VbaCompiler for Excel  v.1.2VBA compiler converts VBA code of Microsoft Excel workbooks and Excel add-ins into binary code (native Windows DLL file). After compilation your VBA code cannot be copied or recovered and has the highest level of protection from piracy.
  • MTools Pro Excel Addin  v.1.12The excel add-in MTools is a powerful software, that leverages the efficiency of your daily work with its timesaving functions and their capability of being applied to multiple (protected) sheets as well as to multiple closed spreadsheets.
  • MTools Excel Addin  v.1.12The excel add-in MTools is a powerful software, that leverages the efficiency of your daily work with its timesaving functions and their capability of being applied to multiple (protected) sheets as well as to multiple closed spreadsheets.
  • 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.