Count function help - determining "drive time" distance

[GCarpenter]

Hello,

Is the below example possible? I've been able to determine how many people live within a certain distance (in miles), thanks to this board (thank you!), but now I'm looking to determine how many people live "within a 30 minute drive", using lat. long. coordinates as the reference points.

Is there a routine built for this type of problem as well??

Thanks in advance!

*Note not cross-posted / only posted here*

 

[cooper645]

there is another thread on Mr Excel that looks at calculating distance between 2 long/lat points,

The post for the distance is here

However I believe what you need is to use a Bing maps or Google maps API (both free I believe) to achieve what you need. There is an in depth example on another website here which looks at how to achieve this. There is a template available here too which may be a good starting point.

I hope this helps you in the right direction a little.

Coops

 

[GCarpenter]

there is another thread on Mr Excel that looks at calculating distance between 2 long/lat points,

The post for the distance is here

However I believe what you need is to use a Bing maps or Google maps API (both free I believe) to achieve what you need. There is an in depth example on another website here which looks at how to achieve this. There is a template available here too which may be a good starting point.

I hope this helps you in the right direction a little.

Coops

Any idea how this would look for my example?

 

[cooper645]

Sadly not, I just figured it might be a good palace for you to start. It seemed like it was what you were trying to achieve.