Post Code

A

Adam

I have a column that contains lots of post codes.

E.g

EH48 3SS
EH48 3HU
EH52 6PQ
EH48 3OP
EH48 3ER
EH52 6XW

I'd like to count how many post codes I have that contain "EH48" in the
cell. Could someone tell me how I do this?

Thanks
 
D

Darrilyn

Here is my thinking. In a separate column you will need to separate the
first four characters out (EH48, EH52, etc....) by typing in =left(clicking
on the cell that contains the postal code,4). Then at the end of the column
you can type in =countif(select the range of the newly separated
characters,"EH48") Hope this helps
 
Top