{"id":212,"date":"2023-11-11T13:06:23","date_gmt":"2023-11-11T13:06:23","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/"},"modified":"2023-12-25T10:25:09","modified_gmt":"2023-12-25T10:25:09","slug":"valor-mas-bajo","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/","title":{"rendered":"\u00bfc\u00f3mo encontrar el valor m\u00e1s bajo en una lista de n?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4177959412\"><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>En Excel, para encontrar los valores m\u00e1s bajos en una lista de n\u00fameros, debe usar la funci\u00f3n PEQUE\u00d1A. Con esta funci\u00f3n no solo puede obtener el valor m\u00e1s peque\u00f1o sino tambi\u00e9n el segundo, tercero, cuarto o incluso el k\u00e9simo m\u00e1s peque\u00f1o de la lista. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79856\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-la-plus-basse-de-la-liste.png\" sizes=\"auto, \" srcset=\"\" alt=\"valor m\u00e1s bajo en la lista\" width=\"397\" height=\"511\"><\/figure>\n<\/div>\n<p> En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula usando esta funci\u00f3n.<\/p>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula de Excel para obtener el n\u00famero m\u00e1s bajo.<\/h2>\n<p> Puede utilizar los pasos a continuaci\u00f3n:<\/p>\n<ol type=\"1\">\n<li> Primero, en una celda, ingrese la funci\u00f3n PEQUE\u00d1A.<\/li>\n<li> Despu\u00e9s de eso, en el primer argumento (matriz), haga referencia al rango donde tiene la lista de n\u00fameros.<\/li>\n<li> Luego, en el segundo argumento (k), ingrese 1 porque necesita obtener el <sup>primer<\/sup> n\u00famero m\u00e1s bajo de la lista.<\/li>\n<li> Al final, 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-79857\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-petites-fonctions-pour-obtenir-une-valeur-inferieure.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n peque\u00f1a para obtener un valor m\u00e1s bajo\" width=\"456\" height=\"427\"><\/figure>\n<\/div>\n<p> Una vez que presiona Enter, devuelve 11 en el resultado, que es el n\u00famero m\u00e1s bajo del rango. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79858\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-petit-resultat-de-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"resultado de funci\u00f3n peque\u00f1a\" width=\"470\" height=\"411\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Encuentra el en\u00e9simo valor m\u00e1s bajo de una lista de n\u00fameros<\/h2>\n<p> Y si desea obtener el en\u00e9simo valor m\u00e1s peque\u00f1o de la misma lista, solo necesita cambiar el valor del segundo argumento (k) de la funci\u00f3n. Digamos que quieres obtener el tercer valor m\u00e1s peque\u00f1o, la f\u00f3rmula ser\u00eda: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79859\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nieme-valeur-la-plus-basse.png\" sizes=\"auto, \" srcset=\"\" alt=\"en\u00e9simo valor m\u00e1s bajo\" width=\"479\" height=\"516\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SMALL(A1:A8,3)<\/code><\/pre>\n<p> Devuelve 23, que es el tercer n\u00famero m\u00e1s bajo de la lista.<\/p>\n<h2 class=\"wp-block-heading\"> Encuentra los 3 valores m\u00e1s bajos<\/h2>\n<p> Ahora digamos que necesita obtener los tres valores m\u00e1s bajos en una sola celda. Para hacer esto, debes combinar la funci\u00f3n TEXTJOIN con la funci\u00f3n SMALL. Como en el siguiente ejemplo: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79860\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-les-trois-valeurs-les-plus-basses.png\" sizes=\"auto, \" srcset=\"\" alt=\"los tres valores m\u00e1s bajos\" width=\"493\" height=\"424\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"><code class=\"language-excel-formula\" lang=\"excel-formula\"> =TEXTJOIN(\",\",TRUE,SMALL(A1:A8,{1,2,3}))<\/code><\/pre>\n<p> En la funci\u00f3n PEQUE\u00d1A, usamos {1,2,3} en el argumento k de PEQUE\u00d1A para obtener los 3 valores m\u00e1s bajos de la lista. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79861\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-petite-fonction-pour-obtenir-les-trois-valeurs-les-plus-basses.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-peque\u00f1a-para-obtener-tres-valores-m\u00ednimos\" width=\"487\" height=\"251\"><\/figure>\n<\/div>\n<p> Devuelve 11, 12 y 23 porque son los 3 n\u00fameros m\u00e1s bajos de la lista. Ahora deber\u00edas tener estos tres n\u00fameros en una sola celda. Es por eso que deber\u00edas usar TEXTJOIN. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79862\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-trois-valeurs-les-plus-basses-comme-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"tres-valores-m\u00e1s-bajos-como-resultado\" width=\"440\" height=\"173\"><\/figure>\n<\/div>\n<p> Y si desea obtener los tres valores en tres celdas diferentes, puede omitir el uso de TEXTJOIN. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79863\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-trois-valeurs-les-plus-basses-dans-differentes-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"tres valores m\u00e1s bajos en diferentes celdas\" width=\"624\" height=\"259\"><\/figure>\n<\/div>\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\/nombre-le-plus-bas.xlsx\" rel=\"nofollow\">Descargar<\/a> <\/p>\n<\/div>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s f\u00f3rmulas<\/h2>\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/valores-maximos-promedio\/\">Promedio de los 5 valores m\u00e1s altos en Excel<\/a><\/li>\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-pequeno-2\/\">Encuentre el valor m\u00e1s peque\u00f1o en un rango de celdas (n\u00famero m\u00e1s peque\u00f1o)<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, para encontrar los valores m\u00e1s bajos en una lista de n\u00fameros, debe usar la funci\u00f3n PEQUE\u00d1A. Con esta funci\u00f3n no solo puede obtener el valor m\u00e1s peque\u00f1o sino tambi\u00e9n el segundo, tercero, cuarto o incluso el k\u00e9simo m\u00e1s peque\u00f1o de la lista. En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula usando esta funci\u00f3n. [&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-212","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>\u00bfc\u00f3mo encontrar el valor m\u00e1s bajo en una lista de n?<\/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\/valor-mas-bajo\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo encontrar el valor m\u00e1s bajo en una lista de n?\" \/>\n<meta property=\"og:description\" content=\"En Excel, para encontrar los valores m\u00e1s bajos en una lista de n\u00fameros, debe usar la funci\u00f3n PEQUE\u00d1A. Con esta funci\u00f3n no solo puede obtener el valor m\u00e1s peque\u00f1o sino tambi\u00e9n el segundo, tercero, cuarto o incluso el k\u00e9simo m\u00e1s peque\u00f1o de la lista. En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula usando esta funci\u00f3n. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-la-plus-basse-de-la-liste.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\/valor-mas-bajo\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/\",\"name\":\"\u00bfc\u00f3mo encontrar el valor m\u00e1s bajo en una lista de n?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-la-plus-basse-de-la-liste.png\",\"datePublished\":\"2023-11-11T13:06:23+00:00\",\"dateModified\":\"2023-12-25T10:25:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-la-plus-basse-de-la-liste.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-la-plus-basse-de-la-liste.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo encontrar el valor m\u00e1s bajo en una lista de n?\"}]},{\"@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":"\u00bfc\u00f3mo encontrar el valor m\u00e1s bajo en una lista de n?","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\/valor-mas-bajo\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo encontrar el valor m\u00e1s bajo en una lista de n?","og_description":"En Excel, para encontrar los valores m\u00e1s bajos en una lista de n\u00fameros, debe usar la funci\u00f3n PEQUE\u00d1A. Con esta funci\u00f3n no solo puede obtener el valor m\u00e1s peque\u00f1o sino tambi\u00e9n el segundo, tercero, cuarto o incluso el k\u00e9simo m\u00e1s peque\u00f1o de la lista. En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula usando esta funci\u00f3n. [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:09+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-la-plus-basse-de-la-liste.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\/valor-mas-bajo\/","url":"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/","name":"\u00bfc\u00f3mo encontrar el valor m\u00e1s bajo en una lista de n?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-la-plus-basse-de-la-liste.png","datePublished":"2023-11-11T13:06:23+00:00","dateModified":"2023-12-25T10:25:09+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-la-plus-basse-de-la-liste.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeur-la-plus-basse-de-la-liste.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/valor-mas-bajo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo encontrar el valor m\u00e1s bajo en una lista de n?"}]},{"@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\/212","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=212"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/212\/revisions"}],"predecessor-version":[{"id":1012,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/212\/revisions\/1012"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}