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

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

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

2. ## Re: Help excel = identify the same even / odd pattern in the same position.

https://www.excelforum.com/attachmen...1&d=1525607315
always the last draw for the next

3. ## Re: Help excel = identify the same even / odd pattern in the same position.

Try this in E8:

=IF(MOD(A7,2)=MOD(A8,2),"X","")

Copy across and down.

4. ## Re: Help excel = identify the same even / odd pattern in the same position.

Ok.PHOUCAM,PLEASE! you can get on the worksheet? Every week I will put new pick3
(raffles) the formula has to do automatic
459
159
850
753
159
....

5. ## Re: Help excel = identify the same even / odd pattern in the same position.

I am guessing that you want the cells in columns E:G to remain blank until the new pick3 has been entered. If that is the case then modify Phoucam's formula to read:
Formula:
`Please Login or Register  to view this content.`

Paste the formula into cell E8
Copy across to G8
While E8:G8 are still selected pull the fill handle down as far as necessary.
Let us know if you have any questions.

6. ## Re: Help excel = identify the same even / odd pattern in the same position.

ok jeteMc , esta corret, conglatulations, thank you!

7. ## Re: Help excel = identify the same even / odd pattern in the same position.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1