{"id":584,"date":"2016-11-19T15:09:32","date_gmt":"2016-11-19T15:09:32","guid":{"rendered":"http:\/\/marco-krapf.de\/?page_id=584"},"modified":"2018-10-14T21:38:34","modified_gmt":"2018-10-14T19:38:34","slug":"xl-duplikat-manager","status":"publish","type":"page","link":"https:\/\/marco-krapf.de\/gb\/xl-duplikat-manager\/","title":{"rendered":"xl DuplikatManager"},"content":{"rendered":"

\"Download
\nFree open source tool for finding, deleting and exporting duplicates in an Excel worksheet with lots of extra features – Excel 2010-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>xlDuplikatManager_v2.0<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
GUI 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>538 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>3425<\/td>\n<\/tr>\n
Source lines of code<\/td>2166<\/td>\n<\/tr>\n
Comment lines of code<\/td>574<\/td>\n<\/tr>\n
Blank lines<\/td>685<\/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 as there is no password protection.<\/p>\n

Installation<\/strong>
\nThe 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 2.0<\/strong> \u2013 it\u00b4s free!<\/span><\/h1>\n

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

Manual installation
\n\n\txl DuplikatManager\t(5521 downloads\t)\n<\/a>\n<\/h3>\n

Number of downloads of previous versions: 302<\/p><\/blockquote>\n

Features<\/strong>
\n– Selection of multiple ranges on the worksheet while holding down the Ctrl key
\n<\/span>– Two search modes: consider each selected area separately or merge non-contiguous columns
\n<\/span>– Ignore upper\/lower-case letters and\/or blanks for the search if needed
\n<\/span>– Coloured highlighting of duplicates, unique values or all different values
\n<\/span>– Output duplicates, unique values or all different values<\/span> \u200b\u200bon a new worksheet (optionally the entire rows)
\n<\/span>– Different deletion modes: only duplicates, complete lines, with and without compression (also in combination)
\n<\/span>– Restoration of deleted duplicates possible
\n<\/span>– Jump to individual duplicates with delete and restore function
\n<\/span>– Non-destructive processing (the original content can be restored until a new area is selected or the tool is shut down)
\n<\/span>– Permanent display of the number of duplicates, unique values, different values \u200b\u200band deleted duplicates
\n<\/span>– Integrated quick guide with pictures, tips and examples
\n<\/span>– The tool language can be switched between German and English<\/span><\/span><\/p>\n

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

Donation<\/strong>
\nThis tool 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 finding, deleting and exporting duplicates in an Excel worksheet with lots of extra features – Excel 2010-2019 (Windows optimized) Source code The source code is published on GitHub and can also be opened in the VBA editor as there is no password protection. Installation The tool is shipped as an […]<\/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-584","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\/584","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=584"}],"version-history":[{"count":47,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/584\/revisions"}],"predecessor-version":[{"id":1108,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/584\/revisions\/1108"}],"wp:attachment":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/media?parent=584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}