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

Review Excel List Compare

  • captcha
 
 
New Spreadsheets software
  • 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.