{"id":13963,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/filtrar\/"},"modified":"2021-02-26T08:48:02","modified_gmt":"2021-02-26T08:48:02","slug":"filter","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/filter\/","title":{"rendered":"FILTRAR"},"content":{"rendered":"

Introducci\u00f3n a la Funci\u00f3n FILTRAR<\/h2>\n

La funci\u00f3n FILTRAR en Microsoft Excel y Google Sheets permite a los usuarios extraer informaci\u00f3n que cumpla con ciertos criterios especificados, haci\u00e9ndola una herramienta poderosa para el an\u00e1lisis de datos. La funci\u00f3n devuelve un rango que solo incluye los elementos que cumplen las condiciones establecidas.<\/p>\n

Sintaxis y Ejemplos B\u00e1sicos<\/h2>\n

La sintaxis de la funci\u00f3n FILTRAR es:<\/p>\n

FILTRAR(rango, condici\u00f3n1, [condici\u00f3n2, ...])<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • rango<\/strong>: El rango de celdas que quieres filtrar.<\/li>\n
  • condici\u00f3n1<\/strong>: La condici\u00f3n que debe cumplirse para que las filas del rango sean incluidas en el resultado.<\/li>\n
  • condici\u00f3n2, …<\/strong> (opcional): Condiciones adicionales que deben cumplirse para incluir las filas.<\/li>\n<\/ul>\n
    Ejemplo en Google Sheets:<\/p>\n
    =FILTRAR(A1:B10, B1:B10 > 5)<\/code><\/pre>\n
    Este ejemplo muestra c\u00f3mo filtrar el rango A1:B10 para obtener solo las filas donde los valores en la columna B son mayores que 5.<\/p>\n
    Usos Pr\u00e1cticos de FILTRAR<\/h2>\n
    A continuaci\u00f3n se describen dos escenarios donde la funci\u00f3n FILTRAR puede ser extremadamente \u00fatil:<\/p>\n
    Caso 1: Filtrar Estudiantes Aprobados<\/h2>\n
    Imagina que necesitas filtrar una lista de estudiantes para encontrar solo aquellos que han aprobado un examen, considerando que la nota m\u00ednima para aprobar es 6.<\/p>\n
    Datos de ejemplo:<\/p>\n\n\n\n\n\n\n
    Nombre<\/th>\nNota<\/th>\n<\/tr>\n
    Carlos<\/td>\n5<\/td>\n<\/tr>\n
    Maria<\/td>\n8<\/td>\n<\/tr>\n
    Juan<\/td>\n7<\/td>\n<\/tr>\n
    Ana<\/td>\n4<\/td>\n<\/tr>\n<\/table>\n
    Para filtrar a los estudiantes aprobados, puedes usar la funci\u00f3n FILTRAR de la siguiente manera en Excel o Google Sheets:<\/p>\n
    =FILTRAR(A2:B5, B2:B5 >= 6)<\/code><\/pre>\n
    Este comando filtrar\u00e1 y mostrar\u00e1 solo las filas correspondientes a Maria y Juan, quienes tienen notas de 8 y 7 respectivamente.<\/p>\n
    Caso 2: Seleccionar Productos por Categor\u00eda y Precio<\/h2>\n
    Supongamos que tienes una lista de productos y quieres filtrar aquellos que pertenecen a la categor\u00eda \u00abElectr\u00f3nica\u00bb y cuyo precio es inferior a $500.<\/p>\n
    Datos de ejemplo:<\/p>\n\n\n\n\n\n
    Producto<\/th>\nCategor\u00eda<\/th>\nPrecio<\/th>\n<\/tr>\n
    Televisor<\/td>\nElectr\u00f3nica<\/td>\n450<\/td>\n<\/tr>\n
    Licuadora<\/td>\nElectrodom\u00e9sticos<\/td>\n80<\/td>\n<\/tr>\n
    C\u00e1mara<\/td>\nElectr\u00f3nica<\/td>\n320<\/td>\n<\/tr>\n<\/table>\n
    Para realizar el filtrado, se usar\u00eda:<\/p>\n
    =FILTRAR(A2:C4, B2:B4 = \"Electr\u00f3nica\", C2:C4 < 500)<\/code><\/pre>\n
    Las filas mostradas ser\u00e1n las correspondientes a los productos \u00abTelevisor\u00bb y \u00abC\u00e1mara\u00bb, que cumplen ambas condiciones.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Filtrar un rango de datos bas\u00e1ndose en los criterios que defina<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[537],"tags":[],"class_list":["post-13963","post","type-post","status-publish","format-standard","hentry","category-busqueda-y-referencia"],"acf":[],"yoast_head":"\nFunci\u00f3n FILTER (FILTRAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FILTER (FILTRAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/filter\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n FILTER (FILTRAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FILTER (FILTRAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/filter\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:48:02+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n FILTER (FILTRAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/filter\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/filter\/\",\"name\":\"Funci\u00f3n FILTER (FILTRAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:48:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n FILTER (FILTRAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/filter\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/filter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/filter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"B\u00fasqueda y referencia\",\"item\":\"https:\/\/functiontranslator.com\/es\/busqueda-y-referencia\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"FILTRAR\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n FILTER (FILTRAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n FILTER (FILTRAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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:\/\/functiontranslator.com\/es\/filter\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n FILTER (FILTRAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n FILTER (FILTRAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/filter\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:48:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n FILTER (FILTRAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/filter\/","url":"https:\/\/functiontranslator.com\/es\/filter\/","name":"Funci\u00f3n FILTER (FILTRAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:48:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n FILTER (FILTRAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/filter\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/filter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/filter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"B\u00fasqueda y referencia","item":"https:\/\/functiontranslator.com\/es\/busqueda-y-referencia\/"},{"@type":"ListItem","position":3,"name":"FILTRAR"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13963"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13963\/revisions"}],"predecessor-version":[{"id":21866,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13963\/revisions\/21866"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}