{"id":239,"date":"2023-11-10T09:08:34","date_gmt":"2023-11-10T09:08:34","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/"},"modified":"2023-12-25T10:33:38","modified_gmt":"2023-12-25T10:33:38","slug":"numeros-mas-frecuentes","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/","title":{"rendered":"Obtener los n\u00fameros m\u00e1s frecuentes de una matriz"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1413053471\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>Hay dos funciones en Excel que puede utilizar para obtener los n\u00fameros m\u00e1s frecuentes de una lista de n\u00fameros. El primero es MODE y el segundo es MODE.MULT. La primera funci\u00f3n te ayuda a obtener el n\u00famero m\u00e1s frecuente y la segunda te ayuda a obtener m\u00e1s de uno. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79886\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\" sizes=\"auto, \" srcset=\"\" alt=\"obtener los n\u00fameros m\u00e1s frecuentes\" width=\"577\" height=\"418\"><\/figure>\n<\/div>\n<p> Aprendamos ambas f\u00f3rmulas una por una.<\/p>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula para obtener el n\u00famero m\u00e1s frecuente (MODO)<\/h2>\n<p> Puede utilizar los pasos a continuaci\u00f3n:<\/p>\n<ol type=\"1\">\n<li> Primero ingrese la funci\u00f3n MODO en una celda.<\/li>\n<li> Despu\u00e9s de eso, ingrese el par\u00e9ntesis inicial.<\/li>\n<li> Luego consulta el rango donde tienes la lista de n\u00fameros.<\/li>\n<li> Al final, ingrese el par\u00e9ntesis de cierre y presione Enter para obtener el resultado. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79887\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-mode-pour-obtenir-le-numero-le-plus-frequent.png\" sizes=\"auto, \" srcset=\"\" alt=\"modo-para-obtener-el-n\u00famero-\u00fanico-m\u00e1s-frecuente\" width=\"363\" height=\"474\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MODE(A1:A9)<\/code><\/pre>\n<p> MODE es una funci\u00f3n antigua pero todav\u00eda est\u00e1 disponible por compatibilidad con versiones anteriores. Pero hay un defecto en esta funci\u00f3n. Si tiene dos n\u00fameros en una lista que aparecen igualmente en la lista, MODE no podr\u00e1 darle ambos n\u00fameros en el resultado. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79888\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-modes-de-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"modo de resultado\" width=\"371\" height=\"505\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, tienes 30 y 10; Ambos n\u00fameros aparecen cuatro veces en la lista, pero MODE devuelve 30 en el resultado, no 10 ni 10 y 30.<\/p>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula para obtener m\u00faltiples n\u00fameros frecuentes (MODE.MULT)<\/h2>\n<p> Puede utilizar los pasos a continuaci\u00f3n:<\/p>\n<ol type=\"1\">\n<li> Primero ingrese la funci\u00f3n MODE.MULT de Excel en una celda.<\/li>\n<li> Despu\u00e9s de eso, ingrese el par\u00e9ntesis inicial.<\/li>\n<li> A continuaci\u00f3n, consulte el rango de celdas donde tiene la lista de n\u00fameros.<\/li>\n<li> Al final, ingrese el par\u00e9ntesis de cierre y presione Enter para obtener el resultado. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79889\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-obtenir-plusieurs-numeros-frequents.png\" sizes=\"auto, \" srcset=\"\" alt=\"obtener varios n\u00fameros frecuentes\" width=\"377\" height=\"457\"><\/figure>\n<\/div>\n<p> MODE.MULT es una funci\u00f3n de matriz din\u00e1mica que puede devolver resultados en varias celdas. Por eso devuelve 30 y 10 en el resultado, porque ambos n\u00fameros aparecen por igual en la lista.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=MODE.MULT(A1:A9)<\/code><\/pre>\n<p> Y si desea obtener el resultado en forma horizontal dentro de un rango, puede usar la funci\u00f3n TRANSPONER. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79890\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-modes-de-transposition-multi-resultats.png\" sizes=\"auto, \" srcset=\"\" alt=\"modo-transposici\u00f3n.resultado-mult\" width=\"606\" height=\"271\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=TRANSPOSE(MODE.MULT(A1:A9))<\/code><\/pre>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-le-plus-frequent.xlsx\" rel=\"nofollow\">Descargar<\/a><\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/coeficiente-de-variacion\/\">Calcular el coeficiente de variaci\u00f3n (CV) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/maximo-si\/\">MAX SI en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/informe\/\">Calcule r\u00e1pidamente la proporci\u00f3n en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/\">Encuentre el valor m\u00e1s bajo de una lista de n\u00fameros (N)<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hay dos funciones en Excel que puede utilizar para obtener los n\u00fameros m\u00e1s frecuentes de una lista de n\u00fameros. El primero es MODE y el segundo es MODE.MULT. La primera funci\u00f3n te ayuda a obtener el n\u00famero m\u00e1s frecuente y la segunda te ayuda a obtener m\u00e1s de uno. Aprendamos ambas f\u00f3rmulas una por una. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-239","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Obtener los n\u00fameros m\u00e1s frecuentes de una matriz<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Obtener los n\u00fameros m\u00e1s frecuentes de una matriz\" \/>\n<meta property=\"og:description\" content=\"Hay dos funciones en Excel que puede utilizar para obtener los n\u00fameros m\u00e1s frecuentes de una lista de n\u00fameros. El primero es MODE y el segundo es MODE.MULT. La primera funci\u00f3n te ayuda a obtener el n\u00famero m\u00e1s frecuente y la segunda te ayuda a obtener m\u00e1s de uno. Aprendamos ambas f\u00f3rmulas una por una. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:33:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/\",\"name\":\"Obtener los n\u00fameros m\u00e1s frecuentes de una matriz\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\",\"datePublished\":\"2023-11-10T09:08:34+00:00\",\"dateModified\":\"2023-12-25T10:33:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Obtener los n\u00fameros m\u00e1s frecuentes de una matriz\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Obtener los n\u00fameros m\u00e1s frecuentes de una matriz","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/","og_locale":"es_ES","og_type":"article","og_title":"Obtener los n\u00fameros m\u00e1s frecuentes de una matriz","og_description":"Hay dos funciones en Excel que puede utilizar para obtener los n\u00fameros m\u00e1s frecuentes de una lista de n\u00fameros. El primero es MODE y el segundo es MODE.MULT. La primera funci\u00f3n te ayuda a obtener el n\u00famero m\u00e1s frecuente y la segunda te ayuda a obtener m\u00e1s de uno. Aprendamos ambas f\u00f3rmulas una por una. [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:33:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/","url":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/","name":"Obtener los n\u00fameros m\u00e1s frecuentes de una matriz","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png","datePublished":"2023-11-10T09:08:34+00:00","dateModified":"2023-12-25T10:33:38+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-obtenir-les-numeros-les-plus-frequents.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/numeros-mas-frecuentes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"Obtener los n\u00fameros m\u00e1s frecuentes de una matriz"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=239"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/239\/revisions"}],"predecessor-version":[{"id":1487,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/239\/revisions\/1487"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}