sorel Posted September 29, 2019 Share Posted September 29, 2019 precisa da tua ajuda, preciso ativar( colocar na planilia) ela já esta pronta In Q6 copied to Q6:AF1865 & AH6:AW1865 Formula: =IF(ISERROR(MATCH(Q$5,$A6:$O6,FALSE)),"","x") and in AG6 copied down to row 1865 Formula: =COUNTIF(Q6:AF6,"x") ...and similarly for AX6 Quote Link to comment Share on other sites More sharing options...
sorel Posted September 29, 2019 Author Share Posted September 29, 2019 http://www.mediafire.com/file/y1cfypyns28s3e7/dois_setores.xlsx/file nesta planilia, por favor Quote Link to comment Share on other sites More sharing options...
Substantivo Posted September 29, 2019 Share Posted September 29, 2019 (edited) 1 hora atrás, sorel disse: precisa da tua ajuda, preciso ativar( colocar na planilia) ela já esta pronta In Q6 copied to Q6:AF1865 & AH6:AW1865 Formula: =IF(ISERROR(MATCH(Q$5,$A6:$O6,FALSE)),"","x") and in AG6 copied down to row 1865 Formula: =COUNTIF(Q6:AF6,"x") ...and similarly for AX6 IF = SE ISERROR = SEERRO MATCH = CORRESP COUNTIF= CONT.SE =SE(SEERRO(CORRESP(Q$5;$A6:$O6;FALSO));" ";"x") está formula não está correta =CONT.SE(Q6:AF6;"x") A formula correta é =SEERRO(SE(CORRESP(Q5;$A6:$O6;0);"x");"") Edited September 29, 2019 by Substantivo complemento resposta Quote Link to comment Share on other sites More sharing options...
sorel Posted September 29, 2019 Author Share Posted September 29, 2019 ok teve traduzir para o portugues? SUBS colocar na planilia?, abraço Quote Link to comment Share on other sites More sharing options...
sorel Posted September 29, 2019 Author Share Posted September 29, 2019 ola substantivo tem copiar colar nao consegui, consegue por na planilai por favor! Quote Link to comment Share on other sites More sharing options...
Substantivo Posted September 29, 2019 Share Posted September 29, 2019 Copie a formula correta e cole em Q6 Quote Link to comment Share on other sites More sharing options...
sorel Posted September 29, 2019 Author Share Posted September 29, 2019 esta dando erro, nao funcionou, Quote Link to comment Share on other sites More sharing options...
sorel Posted September 29, 2019 Author Share Posted September 29, 2019 sim, eu coloquei pedindo num forum, nao foi pega na internet nao, eu fiz assim coloquei na planilia e nao funciona Quote Link to comment Share on other sites More sharing options...
sorel Posted September 29, 2019 Author Share Posted September 29, 2019 ok , ficou, bom pedepano, uma pergunta se alguem de um forum de excel ajudar com formula em excel tenho que traduzir? aonde posso aprender a ativar formulas? um forte abraço obrigado por ver o post objetivo foi ver estatisticas por setor, sim paor coluna se pode ver atrasos( espaços em branco) pedepano, se conseguir ver repetiçoes e ausentes em cada um setores seria otimo Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.