{"id":310,"date":"2023-11-05T06:20:08","date_gmt":"2023-11-05T06:20:08","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/"},"modified":"2023-12-06T11:50:43","modified_gmt":"2023-12-06T11:50:43","slug":"encontre-o-ultimo-valor-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/","title":{"rendered":"Encontre o \u00faltimo valor em uma coluna ou linha"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-624237315\"><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><div class=\"excel-before-content\" id=\"excel-2230473423\"><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>No Excel, existem duas maneiras de encontrar um valor em uma coluna ou linha. Neste tutorial aprenderemos como usar os dois tipos de f\u00f3rmulas e tentar abord\u00e1-las em diferentes situa\u00e7\u00f5es.<\/p><h2 class=\"wp-block-heading\"> Encontre o \u00faltimo valor (quando o \u00faltimo valor est\u00e1 na \u00faltima c\u00e9lula)<\/h2><p> Siga estas etapas para escrever esta f\u00f3rmula:<\/p><ol type=\"1\"><li> Primeiro insira a fun\u00e7\u00e3o INDEX em uma c\u00e9lula.<\/li><li> Depois disso, no argumento <strong>do array<\/strong> , consulte o intervalo de valores.<\/li><li> Em seguida, no argumento <strong>rows<\/strong> , insira a fun\u00e7\u00e3o ROWS.<\/li><li> Na fun\u00e7\u00e3o ROWS, consulte o intervalo em que voc\u00ea possui valores.<\/li><li> No final, insira os par\u00eanteses de fechamento e pressione Enter para obter o resultado. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82465\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-recherche-de-la-derniere-valeur-dune-cellule-ou-dune-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"pesquisar o \u00faltimo valor de uma c\u00e9lula ou linha\" width=\"440\" height=\"139\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(A1:A4,ROWS(A1:A4))<\/code><\/pre><p> No momento em que voc\u00ea pressiona Enter, ele retorna o valor da \u00faltima c\u00e9lula do intervalo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82454\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-valeur-de-la-derniere-cellule-de-la-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"valor da \u00faltima c\u00e9lula do intervalo\" width=\"439\" height=\"243\"><\/figure><\/div><p> O <strong>\u00fanico problema com esta f\u00f3rmula<\/strong> \u00e9 quando voc\u00ea n\u00e3o tem um valor na \u00faltima c\u00e9lula do intervalo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82456\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-aucune-valeur-dans-la-derniere-cellule-de-la-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"nenhum valor na \u00faltima c\u00e9lula do intervalo\" width=\"402\" height=\"205\"><\/figure><\/div><p> Portanto, podemos passar para a f\u00f3rmula da qual falaremos a seguir.<\/p><h2 class=\"wp-block-heading\"> Encontre o \u00faltimo valor na coluna<\/h2><p> Voc\u00ea tamb\u00e9m pode usar a fun\u00e7\u00e3o PESQUISAR. E a f\u00f3rmula ser\u00e1:<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=LOOKUP(2,1\/(A:A&lt;&gt;\"\"),A:A)<\/code><\/pre><p> LOOKUP tem duas sintaxes a seguir e usamos sintaxe vetorial. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82457\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-rechercher-la-derniere-valeur-dans-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"pesquisa-\u00faltimo-valor-na-coluna\" width=\"287\" height=\"103\"><\/figure><\/div><h3 class=\"wp-block-heading\"> (A:A&lt;&gt;&#8221;)<\/h3><p> Esta parte da f\u00f3rmula retorna uma matriz ap\u00f3s testar se uma c\u00e9lula possui um valor.<\/p><p> Aqui nos referimos \u00e0 coluna inteira e \u00e9 por isso que ela retornou um array grande. Mas nos tr\u00eas primeiros valores voc\u00ea pode ver que temos VERDADEIRO, isso porque temos os valores nas tr\u00eas primeiras c\u00e9lulas da coluna A <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82458\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-fait-reference-a-la-colonne-entiere.png\" sizes=\"auto, \" srcset=\"\" alt=\"refer\u00eancia a coluna inteira\" width=\"523\" height=\"151\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 1\/(A:A&lt;&gt; \u00bb \u00bb)<\/h3><p> E quando voc\u00ea divide 1 por todo o array retornado pela parte anterior da f\u00f3rmula, voc\u00ea obt\u00e9m 1 para TRUE e ;#DIV\/0! para todos os valores FALSE. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82460\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-renvoye-par-la-partie-precedente-de-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"retornado pela parte anterior da f\u00f3rmula\" width=\"350\" height=\"124\"><\/figure><\/div><h3 class=\"wp-block-heading\"> R:R<\/h3><p> Nesta parte da f\u00f3rmula, voc\u00ea tem a refer\u00eancia \u00e0 coluna A. E ela retorna um array completo de valores de coluna. Onde a c\u00e9lula est\u00e1 vazia voc\u00ea tem 0 e o valor real onde a c\u00e9lula n\u00e3o est\u00e1 vazia. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82461\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-la-cellule-est-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"c\u00e9lula est\u00e1 vazia\" width=\"398\" height=\"94\"><\/figure><\/div><h3 class=\"wp-block-heading\"> PESQUISA(2,1\/(A:A&lt;&gt;\u201d\u201d),A:A)<\/h3><p> Como mencionei anteriormente, usamos a sintaxe vetorial da fun\u00e7\u00e3o LOOKUP. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82462\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-syntaxe-de-vecteur-de-fonction-de-recherche1.png\" sizes=\"auto, \" srcset=\"\" alt=\"sintaxe de vetor de fun\u00e7\u00e3o de pesquisa\" width=\"351\" height=\"205\"><\/figure><\/div><ul><li> No vetor LOOKUP, temos todos os valores como 1 e 0. 1 onde temos os valores no vetor RESULT, e 0 onde n\u00e3o temos valores no vetor resultado.<\/li><li> Quando voc\u00ea procura 2 no intervalo onde h\u00e1 1 em todos os valores, a fun\u00e7\u00e3o SEARCH refere-se ao \u00faltimo 1 no vetor SEARCH.<\/li><li> Em seguida, ele retorna o valor correspondente do vetor de resultado. Este \u00faltimo valor \u00e9 o \u00faltimo valor exato da coluna A. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82463\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-valeur-correspondante-du-vecteur-de-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"valor correspondente do vetor de resultado\" width=\"488\" height=\"269\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Encontrando o \u00faltimo valor de uma linha<\/h2><p> Pode ser usado para obter o valor da \u00faltima c\u00e9lula n\u00e3o vazia de uma linha. Ent\u00e3o voc\u00ea s\u00f3 precisa alterar a refer\u00eancia que voc\u00ea tem. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82464\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-recherche-de-la-valeur-de-la-derniere-ligne1.png\" sizes=\"auto, \" srcset=\"\" alt=\"encontrando o valor da \u00faltima linha\" width=\"512\" height=\"231\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=LOOKUP(2,1\/(1:1&lt;&gt;\"\"),1:1)<\/code><\/pre><p> Nesta f\u00f3rmula, nos referimos \u00e0 linha inteira (Linha 1) para o vetor de pesquisa e aquela no vetor de resultado. E quando voc\u00ea pressiona Enter, ele retorna o valor da c\u00e9lula D1 que \u00e9 a \u00faltima c\u00e9lula n\u00e3o vazia da linha. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtenha o arquivo Excel<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/rechercher-la-derniere-valeur.xlsx\" rel=\"nofollow\">Download<\/a><\/div><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\/pt\/formulas\/\">Lista de f\u00f3rmulas do Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/iferror-vlookup\/\">IFERROR com VLOOKUP no Excel para substituir #N\/A no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/pesquisa-bidirecional\/\">Execute uma pesquisa bidirecional no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/pesquisa-reversa\/\">PROCV invertido (para tr\u00e1s: da direita para a esquerda) no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/correspondencia-vsearch\/\">Combinando VLOOKUP MATCH no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/vlookup-varios-criterios\/\">VLOOKUP com v\u00e1rios crit\u00e9rios no Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","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-310","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>Encontre o \u00faltimo valor em uma coluna ou linha<\/title>\n<meta name=\"description\" content=\"Este tutorial ensinar\u00e1 como escrever uma f\u00f3rmula do Excel para encontrar o \u00faltimo valor em uma coluna ou linha. Vamos verificar isso\u2026\" \/>\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\/pt\/encontre-o-ultimo-valor-2\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Encontre o \u00faltimo valor em uma coluna ou linha\" \/>\n<meta property=\"og:description\" content=\"Este tutorial ensinar\u00e1 como escrever uma f\u00f3rmula do Excel para encontrar o \u00faltimo valor em uma coluna ou linha. Vamos verificar isso\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:50:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-recherche-de-la-derniere-valeur-dune-cellule-ou-dune-ligne.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/\",\"name\":\"Encontre o \u00faltimo valor em uma coluna ou linha\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-recherche-de-la-derniere-valeur-dune-cellule-ou-dune-ligne.png\",\"datePublished\":\"2023-11-05T06:20:08+00:00\",\"dateModified\":\"2023-12-06T11:50:43+00:00\",\"description\":\"Este tutorial ensinar\u00e1 como escrever uma f\u00f3rmula do Excel para encontrar o \u00faltimo valor em uma coluna ou linha. Vamos verificar isso\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-recherche-de-la-derniere-valeur-dune-cellule-ou-dune-ligne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-recherche-de-la-derniere-valeur-dune-cellule-ou-dune-ligne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Encontre o \u00faltimo valor em uma coluna ou linha\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Encontre o \u00faltimo valor em uma coluna ou linha","description":"Este tutorial ensinar\u00e1 como escrever uma f\u00f3rmula do Excel para encontrar o \u00faltimo valor em uma coluna ou linha. Vamos verificar isso\u2026","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\/pt\/encontre-o-ultimo-valor-2\/","og_locale":"pt_PT","og_type":"article","og_title":"Encontre o \u00faltimo valor em uma coluna ou linha","og_description":"Este tutorial ensinar\u00e1 como escrever uma f\u00f3rmula do Excel para encontrar o \u00faltimo valor em uma coluna ou linha. Vamos verificar isso\u2026","og_url":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:50:43+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-recherche-de-la-derniere-valeur-dune-cellule-ou-dune-ligne.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/","url":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/","name":"Encontre o \u00faltimo valor em uma coluna ou linha","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-recherche-de-la-derniere-valeur-dune-cellule-ou-dune-ligne.png","datePublished":"2023-11-05T06:20:08+00:00","dateModified":"2023-12-06T11:50:43+00:00","description":"Este tutorial ensinar\u00e1 como escrever uma f\u00f3rmula do Excel para encontrar o \u00faltimo valor em uma coluna ou linha. Vamos verificar isso\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-recherche-de-la-derniere-valeur-dune-cellule-ou-dune-ligne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-recherche-de-la-derniere-valeur-dune-cellule-ou-dune-ligne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/encontre-o-ultimo-valor-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Encontre o \u00faltimo valor em uma coluna ou linha"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=310"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/310\/revisions"}],"predecessor-version":[{"id":1414,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/310\/revisions\/1414"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}