{"id":8945,"date":"2014-01-18T06:11:15","date_gmt":"2014-01-18T06:11:15","guid":{"rendered":"http:\/\/jurnsearch.wordpress.com\/?p=8945"},"modified":"2014-01-18T06:11:15","modified_gmt":"2014-01-18T06:11:15","slug":"identify-and-extract-the-duplicates-in-an-excel-2007-column-list","status":"publish","type":"post","link":"https:\/\/jurn.link\/jurnsearch\/index.php\/2014\/01\/18\/identify-and-extract-the-duplicates-in-an-excel-2007-column-list\/","title":{"rendered":"Identify and extract duplicates in an Excel 2007 column list"},"content":{"rendered":"

Identify and extract the duplicates in an Excel 2007 column list. It should be a simple one-button task, but Microsoft expects users to jump through hoops<\/a> to do it. To the rescue: the free Duplicate Master 1.4<\/a>, which deftly handles the task with a simple four-click wizard…<\/p>\n

1. Download Duplicate Master<\/a> and extract.
\n2. Double-click on The Duplicate Master.xla<\/em> file, and accept Excel’s warning about ‘enabling macros’. Duplicate Master should load into Excel, to be found in the Add-Ins tab.<\/p>\n

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

3. Load your .xls and select your column of data.
\n4. Call up Duplicate Master, and select your options in it…<\/p>\n

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

Duplicate Master then copies your column’s duplicate entries, automatically opens a new sheet, and copies in the duplicates.<\/p>\n

\n

For future use, either: <\/p>\n

1. Make a desktop shortcut to The Duplicate Master.xla<\/em>, put it in the Windows Start menu, and then call as it up as if it were a program when you have Excel loaded.<\/p>\n

or… 2. Pin Duplicate Master to the Add-ins tab by following these steps: Open the Excel 2007 Start Orb | Excel Options | Add-ins | Managed Excel Add-ins + GO | Browse… load The Duplicate Master.xla<\/em> | OK, OK, and quit.<\/p>\n","protected":false},"excerpt":{"rendered":"

Identify and extract the duplicates in an Excel 2007 column list. It should be a simple one-button task, but Microsoft …<\/p>\n

Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-8945","post","type-post","status-publish","format-standard","hentry","category-jurn-tips-and-tricks"],"_links":{"self":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts\/8945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/comments?post=8945"}],"version-history":[{"count":0,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts\/8945\/revisions"}],"wp:attachment":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/media?parent=8945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/categories?post=8945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/tags?post=8945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}