I'm working on a summary of premium postcode deliveries, whereby I have a sheet with raw data, and a summary sheet which tells me how many times the postcode appears.
The problem is that sometimes we're interested in a different number of digits of the postcode for instance:
IV (all IV postcodes)
or
IV6 (Only IV6 not any other IV codes)
or
IV6 1 (only IV6 1 codes not any other IV6 codes)
I have about 50 postcodes entries (i.e. IV, ED6, TR12 4) in total to summarize. Is there a quick way to count the number of occurrences of each from the list?
I bodged up a way that works yesterday, but the postcode data is 64000 rows long, and my method effectively mirrored this 5 times (and crashes my machine every 5 mins). I'll post an example of how I bodged if no-one has any simpler ideas (otherwise I'd rather not embarrass myself lol).
Bookmarks