Hi Everyone,

I have been using the simple formula;

< =COUNTIFS(H:H,">=1",D:D,"WA1*") >

to COUNT when a range equals a partial postcode, in this instance WA1 and it works great. However I am having an issue of double counting when I have a postcode such as WA11 when it then counts the WA1 and WA11 results as one hit.

Is there a way around this problem without having a list of all postcodes and doing a VLOOKUP?

Thanks in advance for your help,

E.