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