Help excel = identify the same even / odd pattern in the same position

[jack]

Help excel = identify the same even / odd pattern in the same position
* From last to next
Par = 0,2,4,6,8
Odd = 1,3,5,7,9
Example on pick3
1st 2nd 3rd
4 5 6
9 0 2
* In the third position it repeated the same pattern for 6 to 2 in the standard par = 0,2,4,6,8
* Objective = to see which of the three positions repeats the pattern, is different from how the digit repeats

 

[jack]

http://www.mediafire.com/file/ypcypa7keq0f19r/patterns_pick3.xlsx

 

[jack]

always the last draw for the next

 

[Frank]

http://www.mediafire.com/file/mmm3qc4axk1cep9/Copy_of_patterns_pick3.xlsx

 

[jack]

Ok frank, we have a problem, the value zero in the even pattern, is not recognized
Ex = 029
******* 018
The formula does not recognize the zero-value pattern as par
The rest is perfect

 

[Frank]

Ok frank, we have a problem, the value zero in the even pattern, is not recognized
Ex = 029
******* 018
The formula does not recognize the zero-value pattern as par
The rest is perfect

Its the same problem as last time, In cell E8 change the beginning of the formula (=IF(A8....etc by adding <>"") so it reads:-

=IF(A8<>"",IF(AND(ISEVEN(A7),ISEVEN(A8))+AND(ISODD(A7),ISODD(A8)),"x",""),"").

Copy the fromula across, then down all the rows. It was like that to stop x appearing on empty rows.

 

[jack]

ok, thank you frank