{"id":1042,"date":"2013-08-29T12:03:05","date_gmt":"2013-08-29T12:03:05","guid":{"rendered":"http:\/\/sites.uac.pt\/amendes\/?p=1042"},"modified":"2013-08-29T12:03:05","modified_gmt":"2013-08-29T12:03:05","slug":"excel-esconder-valores-duplicados","status":"publish","type":"post","link":"https:\/\/sites.uac.pt\/amendes\/software\/excel-esconder-valores-duplicados\/","title":{"rendered":"Excel: Esconder valores duplicados"},"content":{"rendered":"<div id=\"attachment_416\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.techrepublic.com\/blog\/window-on-windows\/a-quick-trick-for-hiding-duplicate-excel-values\/6561?tag=nl.e064&amp;s_cid=e064\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-416\" class=\"size-medium wp-image-416\" src=\"http:\/\/sites.uac.pt\/amendes\/files\/2011\/10\/techRepublic-300x82.png\" alt=\"Tip para esconder valores repetidos usando formata\u00e7\u00e3o condicional\" width=\"300\" height=\"82\" srcset=\"https:\/\/sites.uac.pt\/amendes\/files\/2011\/10\/techRepublic-300x82.png 300w, https:\/\/sites.uac.pt\/amendes\/files\/2011\/10\/techRepublic.png 394w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-416\" class=\"wp-caption-text\">Tip para esconder valores repetidos usando formata\u00e7\u00e3o condicional<\/p><\/div>\n<p>Duplicate values aren&#8217;t wrong or bad, but they can be distracting. You  probably won&#8217;t want to delete them, but you might just want to hide  them. For example, the simple sheet below repeats date values in column  A. In a reporting scenario, those duplicate dates might be annoying.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Duplicate values aren&#8217;t wrong or bad, but they can be distracting. You probably won&#8217;t want to delete them, but you might just want to hide them. For example, the simple sheet below repeats date values in column A. In a reporting scenario, those duplicate dates might be annoying.<\/p>\n","protected":false},"author":159,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[150,137],"tags":[123,124],"class_list":["post-1042","post","type-post","status-publish","format-standard","hentry","category-materiais-para-profissionais","category-software","tag-excel","tag-programacao-em-folha-de-calculo"],"_links":{"self":[{"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/posts\/1042","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/users\/159"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/comments?post=1042"}],"version-history":[{"count":2,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/posts\/1042\/revisions"}],"predecessor-version":[{"id":1044,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/posts\/1042\/revisions\/1044"}],"wp:attachment":[{"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/media?parent=1042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/categories?post=1042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.uac.pt\/amendes\/wp-json\/wp\/v2\/tags?post=1042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}