Hi

I'm trying to write a formula that searches a range to values based on but I
can't get it to work.

The range is column C

the problem is when I get to a postcode that has only 1 letter. I am
currently using sumproduct to check the range and using left(B37, 2) to get
only the first 2 letters. If B37 contains NG, I get the count of all
postcodes with NG but some postcodes only have 1 letter. When this happens, I
get ALL postcodes that start with N instead of postcodes that only have N

is there a formula? I've been down the road of If Then formulas and countif
etc but I can't make the filter.


Any help would be really appreciated


Nigel