{"id":311,"date":"2023-11-05T05:34:48","date_gmt":"2023-11-05T05:34:48","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/"},"modified":"2023-12-06T11:50:59","modified_gmt":"2023-12-06T11:50:59","slug":"gerar-grupos-aleatorios","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/","title":{"rendered":"Gere grupos aleat\u00f3rios no excel"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1628935822\"><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-1773909378\"><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> <ul><li>Grupos aleat\u00f3rios com tamanho aleat\u00f3rio (CHOOSE + RANDBETWEEN)<\/li><li> Grupos aleat\u00f3rios do mesmo tamanho (RAND + ROUND + RANK)<\/li><\/ul><p> Em ambos os m\u00e9todos, precisamos escrever uma f\u00f3rmula. E neste tutorial, aprenderemos as duas formas e as entenderemos em detalhes. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82491\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-generer-des-groupes-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"gerar grupos aleat\u00f3rios\" width=\"622\" height=\"392\"><\/figure><\/div><p> Neste exemplo, voc\u00ea tem uma lista de alunos com seus nomes e agora precisa atribuir a eles um grupo aleat\u00f3rio de norte, sul, leste e oeste.<\/p><h2 id=\"h-generating-random-groups-in-excel\" class=\"wp-block-heading\"> Gerando grupos aleat\u00f3rios no Excel<\/h2><p> Para escrever esta f\u00f3rmula, voc\u00ea pode usar as etapas abaixo:<\/p><ol type=\"1\"><li> Primeiro, em uma c\u00e9lula, insira a fun\u00e7\u00e3o CHOOSE.<\/li><li> E no primeiro argumento de CHOOSE, que \u00e9 index_num, insira a fun\u00e7\u00e3o RANDBETWEEN.<\/li><li> Agora em RANDBETWEEN digite \u201c1\u201d na parte inferior e \u201c4\u201d na parte superior. Ent\u00e3o voc\u00ea tem quatro grupos para obter o resultado; \u00e9 por isso que voc\u00ea precisa usar 1 e 4 para criar um intervalo de n\u00fameros aleat\u00f3rios.<\/li><li> Em seguida, no segundo argumento de CHOOSE, insira o nome dos quatro grupos entre aspas (\u201cNorte\u201d, \u201cSul\u201d, \u201cLeste\u201d, \u201cOeste\u201d).<\/li><li> No final, pressione Enter para obter o resultado. E arraste a f\u00f3rmula at\u00e9 o sobrenome. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82490\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-generer-un-groupe-aleatoire-dans-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"gerar grupo aleat\u00f3rio no Excel\" width=\"676\" height=\"377\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Nota:<\/strong> RANBBETWEEN \u00e9 uma fun\u00e7\u00e3o vol\u00e1til que \u00e9 atualizada quando voc\u00ea edita sua planilha.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CHOOSE(RANDBETWEEN(1,4),\"North\",\"South\",\"East\",\"West\")<\/code><\/pre><h3 id=\"h-how-this-formula-works\" class=\"wp-block-heading\"> Como funciona essa f\u00f3rmula?<\/h3><p> Para entender essa f\u00f3rmula \u00e9 preciso dividi-la em duas partes: Na primeira parte temos RANDBETWEEN, que retorna um n\u00famero aleat\u00f3rio entre 1 e 4 (porque temos quatro grupos). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82492\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-premiere-partie-a-une-fonction-randbetween.png\" sizes=\"auto, \" srcset=\"\" alt=\"primeira parte-a-randentre-fun\u00e7\u00e3o\" width=\"575\" height=\"126\"><\/figure><\/div><p> Na segunda parte, temos a fun\u00e7\u00e3o CHOOSE, que retorna um valor da lista que voc\u00ea define usando index_number. Quando RANDBETWEEN retorna um n\u00famero aleat\u00f3rio, CHOOSE retorna o valor da lista usando esse n\u00famero. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82493\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-deuxieme-partie-a-choisir-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"fun\u00e7\u00e3o de segunda parte para escolher\" width=\"425\" height=\"105\"><\/figure><\/div><p> Quando voc\u00ea tem 3 no n\u00famero do \u00edndice, SELECT retorna \u201cIs\u201d no resultado.<\/p><h3 id=\"h-but-there-s-a-problem\" class=\"wp-block-heading\"> Mas h\u00e1 um problema.<\/h3><p> Ao usar esta f\u00f3rmula, n\u00e3o h\u00e1 agrupamento do mesmo tamanho. Ent\u00e3o voc\u00ea pode ver no resultado que os grupos atribu\u00eddos aos alunos n\u00e3o s\u00e3o do mesmo tamanho. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82494\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-groupes-attribues-ne-sont-pas-de-la-meme-taille.png\" sizes=\"auto, \" srcset=\"\" alt=\"grupos afetados n\u00e3o s\u00e3o do mesmo tamanho\" width=\"613\" height=\"369\"><\/figure><\/div><p> Este m\u00e9todo s\u00f3 \u00e9 apropriado quando voc\u00ea n\u00e3o deseja levar em considera\u00e7\u00e3o o tamanho do grupo; caso contr\u00e1rio, voc\u00ea precisar\u00e1 usar a f\u00f3rmula sobre a qual falaremos a seguir.<\/p><h2 id=\"h-generating-random-groups-same-size\" class=\"wp-block-heading\"> Gera\u00e7\u00e3o de grupos aleat\u00f3rios (mesmo tamanho)<\/h2><p> Para usar esta f\u00f3rmula, voc\u00ea precisa <strong>criar uma coluna auxiliar<\/strong> com a fun\u00e7\u00e3o RAND para obter o n\u00famero aleat\u00f3rio entre 0 e 1 da seguinte maneira. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82495\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-generer-des-groupes-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"gerar grupos aleat\u00f3rios\" width=\"392\" height=\"431\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Nota:<\/strong> RAND tamb\u00e9m \u00e9 uma fun\u00e7\u00e3o vol\u00e1til que altera seu valor. E aqui vou converter a <a href=\"https:\/\/exceladvisor.org\/pt\/formula-para-valor\/\" data-wpil=\"url\">f\u00f3rmula em valores<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82496\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-volatile-a-7-rands.png\" sizes=\"auto, \" srcset=\"\" alt=\"fun\u00e7\u00e3o rand-vol\u00e1til\" width=\"416\" height=\"191\"><\/figure><\/div><p> <strong>Depois disso<\/strong> , insira uma nova coluna e a fun\u00e7\u00e3o RANK. Ent\u00e3o, no argumento num\u00e9rico, especifique o n\u00famero aleat\u00f3rio de B2; no argumento ref, use todo o intervalo de n\u00fameros aleat\u00f3rios. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82497\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-gamme-complete-de-nombres-aleatoires.png\" sizes=\"auto, \" srcset=\"\" alt=\"intervalo inteiro de n\u00fameros aleat\u00f3rios\" width=\"493\" height=\"410\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=RANK(B2,$B$2:$B$13)<\/code><\/pre><p> Ele cria uma classifica\u00e7\u00e3o \u00fanica para os 12 alunos que voc\u00ea tem na lista. <strong>Agora<\/strong> voc\u00ea precisa dividir essa classifica\u00e7\u00e3o por tr\u00eas, pois voc\u00ea precisa ter tr\u00eas alunos em um \u00fanico grupo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82498\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-cree-un-classement-unique.png\" sizes=\"auto, \" srcset=\"\" alt=\"crie uma classifica\u00e7\u00e3o \u00fanica\" width=\"529\" height=\"201\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=RANK(B2,$B$2:$B$13)\/3<\/code><\/pre><p> <strong>Ent\u00e3o<\/strong> voc\u00ea precisa usar ROUNDUP para arredondar essas classifica\u00e7\u00f5es. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82499\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-roundup-pour-arrondir-le-classement-vers-le-haut.png\" sizes=\"auto, \" srcset=\"\" alt=\"classifica\u00e7\u00e3o rodada a rodada\" width=\"516\" height=\"426\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=ROUNDUP(RANK(B2,$B$2:$B$13)\/3,0)<\/code><\/pre><p> Depois de usar o ROUNDUP, voc\u00ea obt\u00e9m um grupo de tamanho igual onde cada grupo tem o mesmo n\u00famero de alunos (12 alunos em todos os quatro grupos com tr\u00eas alunos em cada grupo). Ent\u00e3o, novamente, use SELECT para converter esses grupos de n\u00fameros em nomes de grupos. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82500\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-groupes-de-taille-egale.png\" sizes=\"auto, \" srcset=\"\" alt=\"grupo de tamanho uniforme\" width=\"535\" height=\"465\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CHOOSE(ROUNDUP(RANK(B2,$B$2:$B$13)\/3,0),\"North\",\"South\",\"East\",\"West\")<\/code><\/pre><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\/groupe-aleatoire.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\/filtro-horizontal\/\">Crie um filtro horizontal no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/classificacao-por-estrelas\/\">Crie um modelo de classifica\u00e7\u00e3o por estrelas no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/obter-o-nome-do-arquivo\/\">Obtenha o nome do arquivo no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/obter-o-nome-da-planilha\/\">Obtenha o nome da planilha no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/gerar-letras-aleatorias\/\">Gere letras aleat\u00f3rias rapidamente 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-311","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>Gere grupos aleat\u00f3rios no Excel<\/title>\n<meta name=\"description\" content=\"Este tutorial ensinar\u00e1 como escrever f\u00f3rmulas Excel para gerar grupos aleat\u00f3rios. 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\/gerar-grupos-aleatorios\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gere grupos aleat\u00f3rios no Excel\" \/>\n<meta property=\"og:description\" content=\"Este tutorial ensinar\u00e1 como escrever f\u00f3rmulas Excel para gerar grupos aleat\u00f3rios. Vamos verificar isso\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:50:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-generer-des-groupes-aleatoires.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\/gerar-grupos-aleatorios\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/\",\"name\":\"Gere grupos aleat\u00f3rios no Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-generer-des-groupes-aleatoires.png\",\"datePublished\":\"2023-11-05T05:34:48+00:00\",\"dateModified\":\"2023-12-06T11:50:59+00:00\",\"description\":\"Este tutorial ensinar\u00e1 como escrever f\u00f3rmulas Excel para gerar grupos aleat\u00f3rios. Vamos verificar isso\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-generer-des-groupes-aleatoires.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-generer-des-groupes-aleatoires.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Gere grupos aleat\u00f3rios no excel\"}]},{\"@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":"Gere grupos aleat\u00f3rios no Excel","description":"Este tutorial ensinar\u00e1 como escrever f\u00f3rmulas Excel para gerar grupos aleat\u00f3rios. 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\/gerar-grupos-aleatorios\/","og_locale":"pt_PT","og_type":"article","og_title":"Gere grupos aleat\u00f3rios no Excel","og_description":"Este tutorial ensinar\u00e1 como escrever f\u00f3rmulas Excel para gerar grupos aleat\u00f3rios. Vamos verificar isso\u2026","og_url":"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:50:59+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-generer-des-groupes-aleatoires.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\/gerar-grupos-aleatorios\/","url":"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/","name":"Gere grupos aleat\u00f3rios no Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-generer-des-groupes-aleatoires.png","datePublished":"2023-11-05T05:34:48+00:00","dateModified":"2023-12-06T11:50:59+00:00","description":"Este tutorial ensinar\u00e1 como escrever f\u00f3rmulas Excel para gerar grupos aleat\u00f3rios. Vamos verificar isso\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-generer-des-groupes-aleatoires.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-generer-des-groupes-aleatoires.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/gerar-grupos-aleatorios\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Gere grupos aleat\u00f3rios no excel"}]},{"@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\/311","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=311"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/311\/revisions"}],"predecessor-version":[{"id":1436,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/311\/revisions\/1436"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}