Forum Discussion
Help with Data Columns
I have a column of Data with a partial postcode, and each one is assigned to a Sales officer. so e.g., CV, B, DY, WV are all assigned to Joe Bloggs for example. In another column I have full postco...
You haven't told us what the full postcodes look like, so I made some up. See the attached demo.
You haven't told us what the full postcodes look like, so I made some up. See the attached demo.
Thanks a lot think that saved me a few days.
- Actually upon checking, for some reason on a few of them, it has returned the wrong sales agent for some reason. So e.g. if im looking for BN8 6QB, and BN is Mrs Joy, its bringing up Mr Patel instead. BB is assigned to Mr Patel, so maybe the formula is getting confused when the full postcode has repeat letters in there?
Can you provide a few examples of what the full postcodes look like?
