Hi Excel Professors,
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
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