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>
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,632
Messages
5,838,472
Members
430,549
Latest member
jayjay2022

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