This is a discussion on Using excel to map or match addresses by zip code or miles within the Excel Questions forums, part of the Question Forums category; I have different addresses on different worksheets within the same workbook. Each worksheet represents a different hotel flagship (so comfort ...
I have different addresses on different worksheets within the same workbook. Each worksheet represents a different hotel flagship (so comfort inn, holiday inn, ect). I'd like a way to match different hotels that are located near each other within excel. The only logical thing I can think of is to match cities and zip codes. Is there another way to see who is located near each other by miles within excel? What formulas would you use to start matching up locations? Thank you.
depending how complex you want to make it I guess the Google Maps API might be your best friend, maybe like this:
Google Maps distance function for Excel | oCoCarbon
or like this:
Distance between postcodes (Using Excel and Google Maps API) - Glen Gilchrist
You can't post attachments here, but you can help me helping you by posting a screen shot directly in your post with any of those tools.
And although it's against forum rules, otherwise use dropbox/google drive/etc to get your file accross.
Finally, please show that you made an effort to solve your problem: Yes, I like to help, but am not going to do your job.