DianaBanana
Board Regular
- Joined
- Mar 10, 2014
- Messages
- 71
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.