R
Rene Petersen
I am trying to make either a VBA automation or a formula to calculate the
below.
The data is found in two columns and every time there is a match it need to
increment the matrix table.
The matrix will have about 100 columns and 200 rows, so it is rather large.
And the data will have about 2-3000 records.
Can anyone solve this challenge?
Data:
Column 1 Column 2
DK 1A
UK 1A
UK 2B
BE 2A
NL 2A
DK 2B
BE 2C
DK 1B
NL 2A
DK 1A
DK 1A
UK 1A
BE 2A
Matrix:
|1A |1B |1C |2A |2B |2C
BE 2 1
DK 3 1 1
NL 2
UK 2 1
Many thanks,
Rene
below.
The data is found in two columns and every time there is a match it need to
increment the matrix table.
The matrix will have about 100 columns and 200 rows, so it is rather large.
And the data will have about 2-3000 records.
Can anyone solve this challenge?
Data:
Column 1 Column 2
DK 1A
UK 1A
UK 2B
BE 2A
NL 2A
DK 2B
BE 2C
DK 1B
NL 2A
DK 1A
DK 1A
UK 1A
BE 2A
Matrix:
|1A |1B |1C |2A |2B |2C
BE 2 1
DK 3 1 1
NL 2
UK 2 1
Many thanks,
Rene