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

 

[Cubist]

It would be helpful if you share some sample data using XL2BB and the expected result. You're more likely to get a faster and more accurate solution this way.

 

[gazmoz17]

Hi, thanks for the reply. Here is an example.

Distance.xlsx
	A
9	DN33 3BH
Sheet1

Thanks

 

[gazmoz17]

DN33 3BH

 

[Cubist]

I think we need more than that. Assuming what you shared is the postcode you want to lookup, what do you want to compare to? You mentioned "caclulate" in the thread title. What do you need to calculate?

 

[gazmoz17]

I dont think thats copied correctly/ its my first time using Xl2bb:

 

[Cubist]

I dont think thats copied correctly/ its my first time using Xl2bb:

Select the range you want to share -> Minisheet -> Ctrl + V to paste.

 

[gazmoz17]

The distance between Col A and col B. Site postcode will be the same all the time (col B)

 

[gazmoz17]

I've clicked min sheet and it seems to of copied to clipboard. But doesnt seem to paste into message correctly.

 

[Cubist]

I've clicked min sheet and it seems to of copied to clipboard. But doesnt seem to paste into message correctly.

You paste it into the reply box of the forum.