Calculate distance between 2 postcode

[gazmoz17]

Hi,

Is it possible to do this in excel? I have a single column of customer postcodes. I wish to compare this column to the same source/origin postcode each time.

So one of the lookup postcodes is the same each time.

Any help much appreciated.

Thanks
Gareth

 

[gazmoz17]

Thanks Cubist. You know what I honestly clocked it was maybe the hours singular (not that I’d of been able to correct the code anyway ) then I forgot I thought it was that when I went back to it .

Thanks for the heads up on it being live. As long as gives a rough indication that would be enough anyway….this is above and beyond what I was expecting. Need to monitor/get to grips with how many API’s its calling and what the cost will be. For this use case (historical leads/static data) it will be fine, I’ll prob just paste as values my output column and save it…then periodically chase up leads.