Looking for a pattern within numbers

Skyline69

Board Regular
Joined
Apr 14, 2013
Messages
145
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

Thank you all in advance

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
C:\Users\Larry\AppData\Local\Temp\msohtmlclip1\01\clip_image002.png
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>
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Skyline69

Board Regular
Joined
Apr 14, 2013
Messages
145
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,493
Messages
5,601,998
Members
414,490
Latest member
Rip181

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top