I'll try to be more precise :) I *do not know* how many times Aaa is folowed
by Xxx - that's what I want to know :) The fact the sequence appears twice
is just because I gave such example :) I have lots of different pairs and I
would like to know how many times given pair occurs within the given range
(it can be more than 8 cells - in fact the matrix has [you - just kidding
:)] several rows and columns filled with the values).

--
Piotrek


So...you want to know how many times the same 2 values appear
consecutively
exactly twice? In your example, you are counting Aaa followed by Xxx
because
that sequence appears 2 times, is that right?



"Piotrek" wrote:

Hello,

I have a little problem with counting pairs of values in vertically
adjacent
cells, hope you can help...

Cells from A1 to A8 contain Aaa, Xxx, Aaa, Xxx, Aaa, Yyy, Bbb, Yyy. I
have
24 similar columns.
Generally, odd rows contain Aaas or Bbbs and even ones - only Xxxs or
Yyys.

Is there a way to count the amount of *pairs* of e.g. Aaas and Xxxs?
(He
2 pairs)

I'll be very grateful for any clues...

--
Thank you very much -
Piotrek