Post Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
How to count merged cells 1
Excel If a Cell Contains a Certain Text (From Another Table) 0
count nonblank cells 3
countifs Function not giving desired result with date criteria 2
Sumproduct with more than one valid criteria 1
count with multiple critirea 4
How do I count cells that contain a number of charctors. 3

Back
Top