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