{"id":593,"date":"2016-11-19T15:30:57","date_gmt":"2016-11-19T15:30:57","guid":{"rendered":"http:\/\/marco-krapf.de\/?page_id=593"},"modified":"2018-10-14T21:39:13","modified_gmt":"2018-10-14T19:39:13","slug":"add-in-xl-pair-compare","status":"publish","type":"page","link":"https:\/\/marco-krapf.de\/gb\/add-in-xl-pair-compare\/","title":{"rendered":"xl PairCompare"},"content":{"rendered":"


\nFree Open-Source-Tool for comparing two selected areas and searching for data record pairs on a worksheet – Excel 2007-2019 (Windows optimized)<\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>xlPairCompareV1P1.xlam<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface languages<\/td>German, English<\/td>\n<\/tr>\n
Where is the add-in after activation?<\/td>\"Data\" tab, next to the \"Data tools\" group<\/td>\n<\/tr>\n
File size<\/td>289 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>3174<\/td>\n<\/tr>\n
Source lines of code<\/td>2271<\/td>\n<\/tr>\n
Comment lines of code<\/td>365<\/td>\n<\/tr>\n
Blank lines<\/td>538<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor.<\/p>\n

Installation
\n<\/strong>The tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> the tool\u00b4s icon is added on the “Data” tab next to the “Data tools” group.<\/p>\n

Download version 1.1<\/strong> \u2013 it\u00b4s free!<\/span><\/h1>\n

Automatic installation (recommended for Windows)
\n\n\txl PairCompare\t(5095 downloads\t)\n<\/a>\n<\/h3>\n

Manual installation
\n\n\txl PairCompare\t(12747 downloads\t)\n<\/a>\n<\/h3>\n

9 downloads of version 1.0<\/p><\/blockquote>\n

Videos<\/strong>
\nTrailer (1:32)<\/a>
\nVideo tutorial: Demonstration of the features (German) (8:05)<\/a><\/p>\n

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

Screenshots<\/strong><\/p>\nngg_shortcode_0_placeholder\n

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

\"Website<\/a><\/p>\n

Donate now!<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"

Free Open-Source-Tool for comparing two selected areas and searching for data record pairs on a worksheet – Excel 2007-2019 (Windows optimized) 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-593","page","type-page","status-publish","hentry"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"gb","enabled_languages":["de","gb"],"languages":{"de":{"title":true,"content":true,"excerpt":false},"gb":{"title":false,"content":true,"excerpt":false}}},"_links":{"self":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/comments?post=593"}],"version-history":[{"count":64,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/593\/revisions"}],"predecessor-version":[{"id":2511,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/593\/revisions\/2511"}],"wp:attachment":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/media?parent=593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}