Thread: How do I calculate the distance between 2 postcodes?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
  
Posts: 703
Default How do I calculate the distance between 2 postcodes?
Well, the formula is

Dist = Sqr((x2 - x1) ^ 2 + (y2 - y1) ^ 2)

for points (x1, y1) to (x2, y2)


"Rhys" wrote:

Can anyone help with this?
Reply With QuoteReply With Quote