2D histogram

[Everett Joline]

If I have two columns of numbers (e.g., 1-8), what is the best way to
generate a 2D (8x8) array that contains the number of occurrences of each
pair of numbers?

Thanks,
E-Jo

 

[Everett Joline]

OK, I was able to do it playing around with a PivotTable (but don't ask me
how!).
Thanks anyway,
E-Jo

 

[BrianB]

Remarkably easy when you convert each pair of numbers to text and us
=COUNTIF().

In my test I put 2 sets of numbers into range A14:B21 and the formula
=A14&B14
copied down in column C when Excel obligingly and automaticall
converts the numbers without having to use the =TEXT() function.

Range b1:i1 contains numbers 1 to 8. Range a2:a9 contains th numbers
to 8. The array table b2:i9 so formed is filled with the formula :-

=COUNTIF($C$14:$C$21,$A2&B$1

 

[BrianB]

Remarkably easy when you convert each pair of numbers to text and us
=COUNTIF().

In my test I put 2 sets of numbers into range A14:B21 and the formula
=A14&B14
copied down in column C when Excel obligingly and automaticall
converts the numbers without having to use the =TEXT() function.

Range b1:i1 contains numbers 1 to 8. Range a2:a9 contains th numbers
to 8. The array table b2:i9 so formed is filled with the formula :-

=COUNTIF($C$14:$C$21,$A2&B$1