{"id":1498,"date":"2015-10-19T21:26:17","date_gmt":"2015-10-20T05:26:17","guid":{"rendered":"http:\/\/systemsolver.com\/StatlerBlog\/?p=1498"},"modified":"2015-10-19T21:26:17","modified_gmt":"2015-10-20T05:26:17","slug":"libre-calc-and-removing-duplicates-create-distinct-values","status":"publish","type":"post","link":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/2015\/10\/19\/libre-calc-and-removing-duplicates-create-distinct-values\/","title":{"rendered":"Libre Calc and removing duplicates &#8211; create distinct values"},"content":{"rendered":"<p><a href=\"http:\/\/superuser.com\/questions\/238656\/openoffice-get-distinct-values-from-column\">http:\/\/superuser.com\/questions\/238656\/openoffice-get-distinct-values-from-column<\/a><\/p>\n<p data-blkn-colour=\"rgba(34,34,34,1)\">found a more simple way to do that:<\/p>\n<ol data-blkn-colour=\"rgba(34,34,34,1)\">\n<li data-blkn-colour=\"rgba(34,34,34,1)\">\n<p data-blkn-colour=\"rgba(34,34,34,1)\">Select the whole column<\/p>\n<\/li>\n<li data-blkn-colour=\"rgba(34,34,34,1)\">\n<p data-blkn-colour=\"rgba(34,34,34,1)\">Data &gt; Filter &gt; Standard Filter<\/p>\n<\/li>\n<li data-blkn-colour=\"rgba(34,34,34,1)\">\n<p data-blkn-colour=\"rgba(34,34,34,1)\">Change &#8216;Field Name&#8217; to -none- , click on &#8216;More options&#8217; and check on &#8216;No duplication&#8217; box<\/p>\n<\/li>\n<\/ol>\n<p data-blkn-colour=\"rgba(34,34,34,1)\">That&#8217;s it. You can copy and paste the filtered fields if you want contiguously numbered cells.<\/p>\n<p data-blkn-colour=\"rgba(34,34,34,1)\">\n<p data-blkn-colour=\"rgba(34,34,34,1)\">** more options at the link<\/p>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/superuser.com\/questions\/238656\/openoffice-get-distinct-values-from-column found a more simple way to do that: Select the whole column Data &gt; Filter &gt; Standard Filter Change &#8216;Field Name&#8217; to -none- , click on &#8216;More options&#8217; and check on &#8216;No duplication&#8217; box That&#8217;s it. You can copy and paste the filtered fields if you want contiguously numbered cells. ** more options at [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1498","post","type-post","status-publish","format-standard","hentry","category-general"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/posts\/1498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/comments?post=1498"}],"version-history":[{"count":0,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/posts\/1498\/revisions"}],"wp:attachment":[{"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/media?parent=1498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/categories?post=1498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/tags?post=1498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}