sorel Posted June 11, 2019 Share Posted June 11, 2019 ativar a formula por favor ela jésta pronta e coloca na planilia In AG6, enter: Formula: =IF(SUMPRODUCT((MOD($A5:$O5,10)=MOD(AG$4,10))+0)>=LEN(AG$4),"x",0) Copy across / down. Quote Link to comment Share on other sites More sharing options...
sorel Posted June 11, 2019 Author Share Posted June 11, 2019 colocar nesta http://www.mediafire.com/file/x5t004xe65epzve/string_duplas_e_trincas.xlsx/file Quote Link to comment Share on other sites More sharing options...
FF882007 Posted June 11, 2019 Share Posted June 11, 2019 boa tarde Sorel =SE(SOMARPRODUTO((MOD($A8:$O8;10)=MOD(AT$4;10))+0)=NÚM.CARACT(AT$4);"X";0) Quote Link to comment Share on other sites More sharing options...
FF882007 Posted June 11, 2019 Share Posted June 11, 2019 TROCAR A8:O8 POR A5:O5 Quote Link to comment Share on other sites More sharing options...
sorel Posted June 11, 2019 Author Share Posted June 11, 2019 grande ff88. trocar? é ser no portugues a formula? Quote Link to comment Share on other sites More sharing options...
sorel Posted June 11, 2019 Author Share Posted June 11, 2019 ok consegui ff88 como voce usaria as strings de triplos e duplas? duvidas??? http://www.mediafire.com/file/m0zmrzrp9b6yrfm/string_duplas_e_trincas_%281%29.xls/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.