How to Count Contiguous Cells if Data equals certain values

[freda]

Hi


I have some data like the following:

2 3 4 8 4 1 3 3 1 8 1 3 5 8 1 2 5 6 1 7 9 3 3

I would like to be able to count the number of times 1 follows 8 for example. For the data above the answer is 2.

If possible I would like a formula that will give me the answer.

I would appreciate some help. thanks.

[:) Sixthsense :)]

In A1 Cell


2 3 4 8 4 1 3 3 1 8 1 3 5 8 1 2 5 6 1 7 9 3 3


In B1 Cell


=LEN(A1)-LEN(SUBSTITUTE(A1,"1 8", " "))