xl PairCompare


Free Open-Source-Tool for comparing two selected areas and searching for data record pairs on a worksheet – Excel 2007-2019 (Windows optimized)

File namexlPairCompareV1P1.xlam
Excel versions2010 or later (Windows)
Interface languagesGerman, English
Where is the add-in after activation?"Data" tab, next to the "Data tools" group
File size289 KB
Lines of code (total)3174
Source lines of code2271
Comment lines of code365
Blank lines538

Source code
The source code is published on GitHub and can also be opened in the VBA editor.

Installation
The tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation the tool´s icon is added on the “Data” tab next to the “Data tools” group.

Download version 1.1 – it´s free!

Automatic installation (recommended for Windows)
xl PairCompare (1319 Downloads)

Manual installation
xl PairCompare (9361 Downloads)

9 downloads of version 1.0

Videos
Trailer (1:32)
Video tutorial: Demonstration of the features (German) (8:05)

Features
– Finding value pairs, i.e. data records that occur in both selected areas
– Highlighting of single values and/or value pairs on the worksheet
– Visualise data record pairs on the worksheet
– Output of detected single values and/or value pairs on the worksheet
– Removing critical characters such as control characters possible
– Ignore lower/upper-case letters and/or spaces possible when comparing
– Quick selection of the areas possible by automatically marking adjacent cells
– GUI can be switched between English and German

Screenshots

Donation
This add-in is being developed and maintained with private effort and provided for free download. I would be very happy about a small donation to this foundation for sick children in the region of Heilbronn/Germany. Read more on the website of the foundation.

Website of the foundation

Donate now!