Counting specific cell pairings

[Spikeyphil]

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

[VBA Noob]

See if this helps

Say data starts in A1 enter this in B2 and drag down

=A1&"-"&A2

VBA Noob

[Spikeyphil]

Hi again,

No joy with that i'm afraid. What I am trying to do is analyse the variables in my dataset for patterns.

The example dataset I used is;

1
1
2
1
3

As this dataset contains 3 variables (1,2,3) there can be 9 different pairings or combinations: 1,1; 1,2; 1,3; 2,1; 2,2; 2,3; 3,1; 3,2 and 3,3.
I need Excel to move through this column starting with the first two cells (i.e. 1,1) and step down 1 cell each time and then tell me the number of times a combination occurs.

Any ideas?

Thanks,

Phil

[VBA Noob]

Closed for cross posting

Please read forum rules below. Cross posting without the link is not permitted. PM me if you agree to the rules

VBA Noob