sorel Posted March 29, 2020 Share Posted March 29, 2020 ola, preciso de ajuda para ativar a formula que conta quantas sequencias se quiser melhorar para o começo da sequencia e fim seria bom no caso sao as posiçoes Resultado: Quote Link to comment Share on other sites More sharing options...
sorel Posted March 29, 2020 Author Share Posted March 29, 2020 esta em ingles voce tem fazer em portugues ou traduzir ry in S2: Formula: =SUM(IF(FREQUENCY(IF((OFFSET($C2:$Q2,,1)-$C2:$Q2)=1,COLUMN(C2:Q2)),IF((OFFSET($C2:$Q2,,1)-$C2:$Q2)<>1,COLUMN(C2:Q2)))=(S$1-1),1,0)) Quote Link to comment Share on other sites More sharing options...
sorel Posted March 29, 2020 Author Share Posted March 29, 2020 ela soma a quantidade de sequencias, mas pode ser melhorada pata ver localizar as posiçoes e o tamanho da sequencia, sim tem tambem a ver as sequencia pela vertical 01 06 11 16 21,02.... 25 ai sim voce pode pegar sequencias um exemplo pedaço de sequencia de 5 horizontal com 5 vertical no carteziano voce vai ter 9 dezena( porque quando cruza perde uma) isto vai valer até para ver sequencia vazias Quote Link to comment Share on other sites More sharing options...
sorel Posted March 29, 2020 Author Share Posted March 29, 2020 sequencia na vertical=01 06 11 16 21 02 07 12 17 22 03 08 13 18 23 04 09 14 19 24 05 10 15 20 25= total sequencias teste 1945 na sequencias vertical= claro tem as normal=01 02 03 04 .....06 07 10 11 13 14 15 20 21 22 23 = 5 tambem np 1945 carteziano= temos sequencial horizontal 01 02 03 04 com vertical 1015 20 capichi Quote Link to comment Share on other sites More sharing options...
sorel Posted March 29, 2020 Author Share Posted March 29, 2020 alguem entendeu? conseguir ver a imagem? Quote Link to comment Share on other sites More sharing options...
sorel Posted March 30, 2020 Author Share Posted March 30, 2020 http://www.mediafire.com/file/vx0e1r15yxfhifn/Counter_Sequencial_%281%29.xlsx/file falta as sequencia pela vertical e alguma filtros Quote Link to comment Share on other sites More sharing options...
sorel Posted April 17, 2020 Author Share Posted April 17, 2020 trincas na sequencia em 99,60% tem no minimo duas pode ter mais 01 02 03 02 03 04 03 04 05 04 05 06 05 06 07 06 07 08 07 08 09 08 09 10 09 10 11 10 11 12 11 12 13 12 13 14 13 14 15 14 15 16 15 16 17 16 17 18 17 18 19 18 19 20 19 20 21 20 21 22 21 22 23 22 23 24 23 24 25 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.