{"id":1093,"date":"2014-11-20T23:14:05","date_gmt":"2014-11-20T21:14:05","guid":{"rendered":"http:\/\/sinetiqueta.com\/wp\/?p=1093"},"modified":"2014-11-20T23:14:05","modified_gmt":"2014-11-20T21:14:05","slug":"contar-celdas-repetidas-de-una-lista","status":"publish","type":"post","link":"https:\/\/www.sinetiqueta.com\/?p=1093","title":{"rendered":"Excel &#8211; Contar celdas repetidas de una lista"},"content":{"rendered":"<p>Probado en Excel 2007 y 2010.<\/p>\n<p>Pongamos que tenemos una lista de diferentes marcas, nombres o valores; y necesitamos saber cuantas veces se repite cada uno de ellos.<\/p>\n<p>En el siguiente ejemplo, veremos como utilizar la funci\u00f3n CONTAR.SI, La f\u00f3rmula el rojo, corresponde a lo que estar\u00eda escrito en la columna D.<\/p>\n<p><a href=\"http:\/\/sinetiqueta.com\/wp\/wp-content\/uploads\/2014\/11\/CONTAR.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1095\" src=\"http:\/\/sinetiqueta.com\/wp\/wp-content\/uploads\/2014\/11\/CONTAR.png\" alt=\"CONTAR\" width=\"468\" height=\"487\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Lo que hacemos es buscar la coincidencia de la columna C, pero si en vez de poner C1, C2, etc&#8230; ponemos \u00abCOCHE\u00bb, tendr\u00edamos el mismo resultado:\u00a0<strong>=CONTAR.SI(A1:A23;\u00bbCOCHE\u00bb).<\/strong><\/p>\n<p>\u00bfEl porqu\u00e9 de esta entrada? F\u00e1cil&#8230; es una nota que as\u00ed no se me olvidar\u00e1 \ud83d\ude1b<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Probado en Excel 2007 y 2010. Pongamos que tenemos una lista de diferentes marcas, nombres o valores; y necesitamos saber cuantas veces se repite cada uno de ellos. En el siguiente ejemplo, veremos como utilizar la funci\u00f3n CONTAR.SI, La f\u00f3rmula&#8230; <a href=\"https:\/\/www.sinetiqueta.com\/?p=1093\" class=\"readmore\">Leer m\u00e1s<span class=\"screen-reader-text\">Excel &#8211; Contar celdas repetidas de una lista<\/span><span class=\"fa fa-angle-double-right\" aria-hidden=\"true\"><\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1097,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[26,205,1],"tags":[204,206,207],"class_list":["post-1093","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-excel","category-uncategorized","tag-contar","tag-excel","tag-funcion","content-layout-excerpt-thumb"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sinetiqueta.com\/index.php?rest_route=\/wp\/v2\/posts\/1093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sinetiqueta.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sinetiqueta.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sinetiqueta.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sinetiqueta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1093"}],"version-history":[{"count":0,"href":"https:\/\/www.sinetiqueta.com\/index.php?rest_route=\/wp\/v2\/posts\/1093\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sinetiqueta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sinetiqueta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sinetiqueta.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}