yogi_Count PostCodes Based On Just The First Letters

Google Spreadsheet   Post  #2557

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-30-2018

question by: Jack Supertramp102:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/zoul4JWWb2c;context-place=mydiscussions

How do i count postcodes based on just the first letters issue

Hi Everyonre,

I have a spreadsheet where i log postcodes at certain times. I need the spreadsheet to count the post code types based on the first letters of the postcode. It does this already but the issue is if i have a postcode in my log L6 and also LL6,, the spreadsheet thinks there is 2 L postcodes. Another example is i have postcode SK7 and S3. The spreadsheet thinks there is 2 S postcodes because they both start with S. I need each postcode type to be counted seperately without this issue.

Spreadsheet sample link below:

https://docs.google.com/spreadsheets/d/1Z3yX4b4cLq2dBfMrrBm3dbwI9U5kMr7XaClaGLxuq-E/edit?usp=sharing

Hope you can help,

Kind Regards,

Jack