Looking for a pattern within numbers

[Skyline69]

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 Said

It Went

Counter

Up

Down

1

U

U

4357

5357

4367

I am trying to capture how many times a specific pattern is displayed

oe

ee

oo

7=12

8=12

7=13

and the pattern is the ee, eo, oo,oe

oo

eo

oe

7=3

8=3

7=4

oo

eo

oe

I want to be able to put in a counter number and it place the calculations in the cells automatically

Example : 2E is counter 4357

2

U

U

4654

5654

4664

4+3=7

E2 and 3

eo

oo

ee

10=9

11=9

10=10

5+7=12

E2 and 3

oo

eo

oo

1=9

2=9

1=1

12=1+2=3

oo

eo

oo

7=3

E4 <tbody> </tbody>

and 7 is o (odd) , 12 is e (even)

3

U

U

4753

5753

4763

B3

oe

ee

oo

11=8

12=8

11=9

ee

oe

eo

2=8

3=8

2=9

ee

oe

eo

4

D

U

5545

6545

5555

eo

oo

ee

10=9

11=9

10=10

oo

eo

oo

1=9

2=9

1=1

oo

eo

oo

5

U

U

5446

6446

5456

oe

ee

oo

9=10

10=10

9=11

oo

oo

oe

9=1

1=1

9=2

oo

oo

oe

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

 

[Skyline69]

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

 

[Akashwani]

Hi and welcome to MrExcel.

You cannot attach your sheet here, but you can post sample data and your expected results using one of the following methods....

Excel Jeanie Html

https://skydrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

Ak