{"id":8869,"date":"2013-12-28T12:14:36","date_gmt":"2013-12-28T12:14:36","guid":{"rendered":"http:\/\/jurnsearch.wordpress.com\/?p=8869"},"modified":"2023-12-03T18:47:49","modified_gmt":"2023-12-03T18:47:49","slug":"excel-example-sheet-compare-lists-and-extract-non-duplicates","status":"publish","type":"post","link":"https:\/\/jurn.link\/jurnsearch\/index.php\/2013\/12\/28\/excel-example-sheet-compare-lists-and-extract-non-duplicates\/","title":{"rendered":"Excel example sheet: compare lists and extract non-duplicates"},"content":{"rendered":"<p>I&#8217;ve been playing around with MS Excel 2007, and found that I wanted to paste in two lists and then have Excel automatically identify and extract all the non-duplicates. The second list is a jumbled up variant of the first, with some new additions in it.  <\/p>\n<p>Here&#8217;s a working .xls file showing my example: <a href=\"https:\/\/jurn.link\/jurnsearch\/wp-content\/uploads\/2013\/12\/excel-sort-two-lists-find-non-duplicates.zip\">excel-sort-two-lists-find-non-duplicates<\/a> (20kb). The embedded formula spots and extracts the new additions, handily placing them directly alongside their occurrence.<\/p>\n<p><a href=\"https:\/\/jurn.link\/jurnsearch\/2013\/12\/excel-example.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/jurn.link\/jurnsearch\/2013\/12\/excel-example.jpg\" alt=\"excel-example\" width=\"529\" height=\"351\" class=\"alignnone size-large wp-image-8871\" \/><\/a><\/p>\n<p>Tip: The formula currently only goes 18 cells down in Column C.  To extend it further, click that 18th cell, spot the little &#8220;+&#8221; in the corner of the cell, and then drag the &#8220;+&#8221; down for as many extra cells as you need.<\/p>\n<p>There are a zillion bits of advice on using Excel to identify duplicates, but not so many for spotting and extracting non-duplicates in this manner.  So hopefully this working example will be of use to someone.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been playing around with MS Excel 2007, and found that I wanted to paste in two lists and then &hellip;<\/p>\n<p><a href=\"https:\/\/jurn.link\/jurnsearch\/index.php\/2013\/12\/28\/excel-example-sheet-compare-lists-and-extract-non-duplicates\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/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-8869","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\/8869","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=8869"}],"version-history":[{"count":2,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts\/8869\/revisions"}],"predecessor-version":[{"id":25630,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts\/8869\/revisions\/25630"}],"wp:attachment":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/media?parent=8869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/categories?post=8869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/tags?post=8869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}