I have tried for some time to use excel functions for the following simple problem:

I have a spreadsheet with two columns (a few thousand rows) having the numbers 1 to 20.

I needs a matrix ( 1- 20 horizontal and 1-20 vertical) showing the number of occurrences of each combination found in the rows.

So I want to know how many times the combination 1-2 occurs, and so forth for all combinations with of 1-20 to 20-20.

Is this possible using standard functions of Excel?

Thanks for your help.

Paul