How do I set up Excel to search nearest resource by address

M

mc303

I need to set up a spreadsheet that will locate the nearest engineer to a
customer's address.
 
M

mc303

I have the resource names, resource post/zip codes and the post/zip codes
that each resource will attend.
 
G

Guest

At its heart this is not an Excel question. First thing
you should do is work this through "by hand" - how can
you achieve this? From that you should get something you
can then implement on a spreadsheet.

Dont know if your postcodes are "meaningful" eg you can
imply something geographically from them. I would think
to do this you wouild need to be able to refer to some
coordinate system so you can deduce & test seperation.


ttfn benm
 
F

Frank Kabel

Hi
so you don't have any real distance information or a separate info about the
distance between different zip codes.
Question: How would you calculate this manually (would you lookup some other
database, etc.)

Bottom line: With only this information not really possible (maybe looking
at the zip codes could help if they follow a rule but for this I could only
provide you with a German specific solution as I don't know your zip code
scheme)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding up to the nearest 1000 1
rounding a number up to a certain ending digit 6
Searching "Up" an Array 3
How do I get a calculated amount to round to the nearest nickel? 3
in access, round up to nearest fraction(.5) 1
Missing address Book 0
rounding figures to nearest thousand 3
round up to nearest 50p 1

Top