Hi,

I have a column of data and I am trying to count the number of times a specific combination of pairs occurs within this column.

E.G.

My column consists of;

1
1
2
1
3

So I need a function which will move down the column analysing 2 cells at a time and then count the frequency of the pairings. In this case it would be 1-1, 1-2, 2-1, 1-3 etc...

Any help gratefully received!

Thanks

Phil