Hello,
I have 8 columns, A, B, C, D, E, F, G, and H Each column has 2669 rows.
A1:A2669
B1:B2669
C1:C2669
D1:D2669
E1:E2669
F1:F2669
G1:G2669
H1:H2669

Each field under each column is a value that has been pasted in from another app. A through to H represents a set (meaning A1, B1, C1, D1, E1, F1, G1, and H1 are the results from one experiment; A2, B2, C2, D2, E2, F2, G2, H2 are the results from a second experiment, etc.)

The values are numbers ranging from 1-5000. COUNTIF permits me to tally up the number of times a specific value (let's say 271) occurs in the A1:A2669 range.

What I need to know is how many times do values occur with one another? i.e. How many times does 271 occur with 318, 599, 202, etc. in relation to all the sets?

Thank you in advance.