Juggler_IN
Active Member
- Joined
- Nov 19, 2014
- Messages
- 349
- Office Version
- 2003 or older
- Platform
- Windows
I need help (VBA Sub) in converting a random two column X, Y data into a summary table which counts number of matched pairs for the ordinal data in X,Y pairs.
Both X and Y can take only integers (1 to 100).
For Example: Consider the following X,Y Data and its Summary Table -
<tbody>
</tbody>
Basically I am looking for a method which can create the summary table on the right for X,Y data with possible values 1 to 100, all integers.
Looking for a VBA subroutine to do this.
Both X and Y can take only integers (1 to 100).
For Example: Consider the following X,Y Data and its Summary Table -
X | Y | [Y] (1) | [Y] (2) | [Y] (3) | [Y] (4) | [Y] (5) | ||
2 | 3 | [X] (1) | 1 | 1 | 0 | 0 | 0 | |
3 | 1 | [X] (2) | 1 | 0 | 2 | 0 | 1 | |
5 | 5 | [X] (3) | 1 | 0 | 0 | 0 | 0 | |
2 | 1 | [X] (4) | 1 | 0 | 0 | 1 | 0 | |
2 | 3 | [X] (5) | 0 | 0 | 0 | 0 | 1 | |
4 | 1 | |||||||
1 | 2 | |||||||
1 | 1 | |||||||
2 | 5 | |||||||
4 | 4 |
<tbody>
</tbody>
Basically I am looking for a method which can create the summary table on the right for X,Y data with possible values 1 to 100, all integers.
Looking for a VBA subroutine to do this.
Last edited: