Hello,
I would like to know how consolidating based on first three characters and count.
Here are the details:
There are a list of postal codes in the sheet SUBSCR, under the column POSTAL.
They need to be consolidated based on the first the characters.
Example:
K1A 0H8
K1A 0M5
K1A 0T8
K1A 0T8
K1B 2U4
K2E 1O6
K2E 9D7
Consolidates to:
KIA
K1B
K2E
There needs to be a count of each three digit in an adjacent column:
K1A 4
K1B 1
K2E 2
Regards,
Yoshi
I would like to know how consolidating based on first three characters and count.
Here are the details:
There are a list of postal codes in the sheet SUBSCR, under the column POSTAL.
They need to be consolidated based on the first the characters.
Example:
K1A 0H8
K1A 0M5
K1A 0T8
K1A 0T8
K1B 2U4
K2E 1O6
K2E 9D7
Consolidates to:
KIA
K1B
K2E
There needs to be a count of each three digit in an adjacent column:
K1A 4
K1B 1
K2E 2
Regards,
Yoshi