classify the pick4 in the 16 patterns of odd pares.

[jack]

classify the pick4 in the 16 patterns of odd paresx
we have 16 possible patterns of odd and even numbers
* the smooth one is for example I'm going to put new drawings in the same format for the formulas to work, please
http://www.mediafire.com/file/4js54274z9ff3yl/16_patterns_pick4.xlsx/file

 

[jack]

b7: =substitute(substitute(text(sumproduct(mod(mid(text(a7, "0000"), {1,2,3,4}, 1), 2) * 10^{3,2,1,0}), "0000"), 0, "e"), 1, "o")

 

[jack]

=IF(BASE(SUMPRODUCT(DECIMAL(IF(ISODD(--MID(TEXT($A7,"0000"),{1,2,3,4},1)),"O","E"),36)*36^{3,2,1,0}),36)=C$6,"x","")

 

[jack]

Hi Frank, can you please activate this formula from the above post? Or can you do another one faster? Can you get it working on the flat? please thank you

 

[Frank]

Hi Frank, can you please activate this formula from the above post? Or can you do another one faster? Can you get it working on the flat? please thank you

Well I can't deal with those fancy elegant formulas, I prefer simple where I can get away with it. Ive added 4 columns to hold each digit, with formulas to find them. You can hide those if you like but dont forget you need to copy the formulas down first.Then its straight forward to use the AND function with ISODD or ISEVEN in the appropriate order to find where the x goes.

http://www.mediafire.com/file/3rkeoiyqokm22mm/16%20patterns%20pick4.xlsx

 

[Frank]

I think the above link has a problem. Try this one .. http://www.mediafire.com/file/ojak6wb3v775f9x/16_patterns_pick4.xlsx/file

 

[jack]

hello,FRANK, ok, good job, can you add in the 16 patterns the delays and the patterns that are sometimes drawn, just like another planilia, please

 

[Frank]

Sorry I'm busy. I didn't sign up to an endless chain of jobs with you wanting more more more. I'm on holiday.
Bye.