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

Review Excel List Compare

  • captcha
 
 
New Spreadsheets software
  • 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 ...
  • QR-Code Native Excel Barcode Generator  v.17.07The Native QR-Code Barcode Generator for Microsoft Excel provides barcoding capability to Microsoft Excel Spreadsheets with an embedded VBA macro making it easy to share sheets without needing to distribute additional fonts or other components.
  • Dose for Excel  v.3.2.8Dose for Excel is a powerful, feature-rich add-in for Microsoft Excel, which allows you to quickly perform functions that would otherwise take up much time.
  • 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.