Hi all,

can anyone come up with an array formula which would count the occurancy of a word(or value) being below a specified word(or value)?

For example count if "A" is below "C" in the following range:

A
B
C
A
C
A
B
C

The result would equal 2 because "A" can be found twice directly under "C".

Thanks!