Noisenverga Posted September 28, 2019 Share Posted September 28, 2019 Planilha verifica a frequencias das dz da LF, vc tem alguma opção de verificar as frequencias das dz como todo o periodo, ou apenas os 10, 25, 50 ou 100 ultimos sorteios. Facil manuseio para os menos experientes em excel. (Simplicidade e funcional 1 Quote Link to comment Share on other sites More sharing options...
NADA É O QUE PARECE Posted September 28, 2019 Share Posted September 28, 2019 Muito obrigado amigo. Quote Link to comment Share on other sites More sharing options...
sorel Posted September 28, 2019 Share Posted September 28, 2019 nois, 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 28, 2019 Share Posted September 28, 2019 esta é a planilia para por a formula http://www.mediafire.com/file/y1cfypyns28s3e7/dois_setores.xlsx/file 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.