1

0

1

0

**0**

1

1

1

1

1

**0**

1

1

1

1

Now, as you can see

**BOLD**numbers is pattern for example pattern for last 3 numbers in given data set it:

**0,1,1**. I want to find next value in set of data

**IF**my patterns occurs in this set of data. So in example above I want Excel to give me result: 1,because number "1" is the number that occurs after given pattern

**0,1,1.**I want Excel to count all "1" and "0" that occurs after given pattern.

I know that I can make another column that helps me in doing that, but I have so much data that my RAM memory can't keep up with all the "helper" columns so I need to find other solution I dont know maybe OFFSET or LOOKUP formula can help me to do this task?

I would love to hear any help from someone who can direct me into right path to solve that problem

Thank you very much in advance

BBXAXX