{"id":10885,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/filtrar\/"},"modified":"2021-02-25T17:19:11","modified_gmt":"2021-02-25T17:19:11","slug":"filter","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/filter\/","title":{"rendered":"FILTRAR"},"content":{"rendered":"

Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o de Filtragem<\/h2>\n

A fun\u00e7\u00e3o FILTRAR, dispon\u00edvel tanto no Microsoft Excel quanto no Google Planilhas, \u00e9 utilizada para retornar um subconjunto de um intervalo de dados baseado em um ou mais crit\u00e9rios espec\u00edficos. Esta fun\u00e7\u00e3o \u00e9 extremamente \u00fatil para an\u00e1lises r\u00e1pidas em conjuntos de dados extensos, permitindo que o usu\u00e1rio visualize apenas as informa\u00e7\u00f5es que satisfazem certas condi\u00e7\u00f5es.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

Para compreender como a fun\u00e7\u00e3o FILTRAR funciona, \u00e9 fundamental conhecer sua sintaxe:<\/p>\n

 FILTRAR(intervalo, condi\u00e7\u00e3o1, [condi\u00e7\u00e3o2, ...]) <\/code><\/pre>\n
    \n
  • intervalo:<\/strong> As c\u00e9lulas que cont\u00eam os dados a serem filtrados.<\/li>\n
  • condi\u00e7\u00e3o1, condi\u00e7\u00e3o2, …:<\/strong> Crit\u00e9rios que determinam quais linhas ser\u00e3o mostradas no resultado. Estas condi\u00e7\u00f5es devem retornar valores booleanos (VERDADEIRO ou FALSO).<\/li>\n<\/ul>\n
    Exemplo 1:<\/strong> Considere uma tabela de vendas com colunas para Vendedor, Produto e Quantidade. Queremos filtrar essa tabela para mostrar apenas as vendas de “Caneta”.<\/p>\n
     =FILTER(A2:C9, B2:B9 = \"Caneta\") <\/code><\/pre>\n
    Neste exemplo, A2:C9<\/code> representa o intervalo completo de dados e B2:B9 = \"Caneta\"<\/code> \u00e9 a condi\u00e7\u00e3o que filtra as linhas onde a coluna de produtos \u00e9 igual a “Caneta”.<\/p>\n
    Aplica\u00e7\u00e3o Pr\u00e1tica da Fun\u00e7\u00e3o de Filtragem<\/h2>\n
    A seguir, s\u00e3o explorados dois cen\u00e1rios pr\u00e1ticos onde a fun\u00e7\u00e3o FILTRAR pode ser utilizada de forma eficaz.<\/p>\n
    Sele\u00e7\u00e3o de Dados Conforme Condi\u00e7\u00f5es Espec\u00edficas<\/h2>\n
    Cen\u00e1rio:<\/strong> Um gerente de vendas deseja examinar apenas as transa\u00e7\u00f5es onde o n\u00famero de itens vendidos supera 50.<\/p>\n
    Solu\u00e7\u00e3o:<\/strong><\/p>\n
     =FILTER(A2:C9, C2:C9 > 50) <\/code><\/pre>\n
    Neste caso, a condi\u00e7\u00e3o C2:C9 > 50<\/code> \u00e9 utilizada para selecionar as linhas com mais de 50 unidades vendidas, permitindo que o gerente concentre-se nas transa\u00e7\u00f5es de maior volume.<\/p>\n
    Combina\u00e7\u00e3o de M\u00faltiplos Crit\u00e9rios<\/h2>\n
    Cen\u00e1rio:<\/strong> Um analista financeiro precisa analisar dados de um cliente espec\u00edfico, “Cliente A”, mas somente para transa\u00e7\u00f5es que ocorreram em 2023.<\/p>\n
    Solu\u00e7\u00e3o:<\/strong><\/p>\n
     =FILTER(A2:D9, (B2:B9 = \"Cliente A\") * (A2:A9 >= DATE(2023,1,1)) * (A2:A9 <= DATE(2023,12,31))) <\/code><\/pre>\n
    Aqui, tr\u00eas condi\u00e7\u00f5es s\u00e3o combinadas: a identifica\u00e7\u00e3o do cliente e o intervalo entre a data inicial e final de 2023. Isso cria um filtro eficaz que limita o conjunto de dados \u00e0s transa\u00e7\u00f5es desejadas.<\/p>\n
    Em suma, a fun\u00e7\u00e3o FILTRAR \u00e9 uma ferramenta poderosa que oferece manipula\u00e7\u00e3o eficiente de dados, facilitando an\u00e1lises complexas de forma simplificada e intuitiva.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Filtra uma gama de dados com base nos crit\u00e9rios que define<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[439],"tags":[],"class_list":["post-10885","post","type-post","status-publish","format-standard","hentry","category-consulta-e-referencia"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o FILTER (FILTRAR) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o FILTER (FILTRAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/filter\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o FILTER (FILTRAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o FILTER (FILTRAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/filter\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:19:11+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o FILTER (FILTRAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\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\/pt-pt\/filter\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/filter\/\",\"name\":\"Fun\u00e7\u00e3o FILTER (FILTRAR) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:19:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o FILTER (FILTRAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/filter\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/filter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/filter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Consulta e refer\u00eancia\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/consulta-e-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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o FILTER (FILTRAR) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o FILTER (FILTRAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/filter\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o FILTER (FILTRAR) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o FILTER (FILTRAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/filter\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:19:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o FILTER (FILTRAR) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/filter\/","url":"https:\/\/functiontranslator.com\/pt-pt\/filter\/","name":"Fun\u00e7\u00e3o FILTER (FILTRAR) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:19:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o FILTER (FILTRAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/filter\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/filter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/filter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Consulta e refer\u00eancia","item":"https:\/\/functiontranslator.com\/pt-pt\/consulta-e-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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10885"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10885\/revisions"}],"predecessor-version":[{"id":25714,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10885\/revisions\/25714"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}