In previous attempts I seem to have had difficulty interpreting the mission.
With that much data would you be willing to reconsider helper columns to lighten the load?
In the attached column C returns postal codes where the pairings are unique. The formula is In helper column D my previous formula that returns row numbers for first occurrences of postal codes is
Then final output of unique postal codes in column E would be and the counts in column F
|
A |
B |
C |
D |
E |
F |
1 |
account number |
postal code |
helper 1 |
helper 2 |
|
|
2 |
12345 |
E2J 4G3 |
E2J 4G3 |
1 |
E2J 4G3 |
2 |
3 |
12345 |
E2J 4G3 |
|
|
S2F 5T5 |
1 |
4 |
12345 |
E2J 4G3 |
|
|
|
|
5 |
98756 |
S2F 5T5 |
S2F 5T5 |
4 |
|
|
6 |
98756 |
S2F 5T5 |
|
|
|
|
7 |
65467 |
E2J 4G3 |
E2J 4G3 |
|
|
|
Bookmarks