Hi all,
Sorry if this type of question has been asked a lot. I've tried to do search for it but haven't been able to find a solution yet.
I'll try to explain this based on an example. Consider the following text:
12.1 1
2.3 4
0.9 2
1.1 3
7.4 1
There are essentially 16 possible values in Column B. For each value, I need to know how many times there's a corresponding value in Column A within a certain range, for example between 0 and 5, between 5 and 10, etc. In the end, I'll need a matrix with the Column B values running down one side, and the ranges across the top, and the number of occurrences filling the matrix.
<5 5<x<10 ....
1 0 1
2 1 ... etc.
3 ....
4
5
Hopefully this is clear. Please help! Thanks.
Bookmarks