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