# Looking for a pattern within numbers

#### Skyline69

##### Board Regular
First and foremost i am a newbie. I mean, I just did take my diapers off. I know quite a bot about using excel but nothing about writing code . I was wondering if it is possible to track numbers and put out a pattern OR at least a quantity of how many of one number groups are displayed. Here is an an example of what I am trying to do

Numbers EE-OO We SaidIt WentCounterUpDown
1UU435753574367I am trying to capture how many times a specific pattern is displayed
oeeeoo7=128=127=13and the pattern is the ee, eo, oo,oe
ooeooe7=38=37=4
ooeooeI want to be able to put in a counter number and it place the calculations in the cells automatically
Example : 2E is counter 4357
2UU4654565446644+3=7E2 and 3
eoooee10=911=910=105+7=12E2 and 3
ooeooo1=92=91=112=1+2=3
ooeooo7=3
 E4

<tbody>
</tbody>
and 7 is o (odd) , 12 is e (even)
3UU475357534763B3
oeeeoo11=812=811=9
eeoeeo2=83=82=9
eeoeeo
4DU554565455555
eoooee10=911=910=10
ooeooo1=92=91=1
ooeooo
5UU544664465456
oeeeoo9=1010=109=11
oooooe9=11=19=2
oooooe

<colgroup><col style="width:48pt" span="17" width="64"> </colgroup><tbody>
</tbody>

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
How do you attach a sheet so I can show you all. I realize this is not a good way to look at what I want to do

Replies
10
Views
1K
Replies
12
Views
781
Replies
8
Views
468
Replies
5
Views
174
Replies
0
Views
118

1,217,383
Messages
6,136,257
Members
450,001
Latest member
KWeekley08

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back