Nearest Store per Customer with MIN and INDEX/MATCH
This lesson is part of the course
In this lesson
You find the nearest Maple & Rye store for every customer town, count the households each store serves and chart the result.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Haversine: Straight-Line Distance from Latitude & Longitude Locked
- Distance Matrix: Every Customer Town × Every Store Locked
- Nearest Store per Customer with MIN and INDEX/MATCH Locked
- Catchment Rings: Counts and Revenue within a Radius Locked
- Drive-Time Proxy: Circuity Factor and Speed Assumptions Locked
- Territory Balancing: Workload per Sales Rep Locked
- Huff Gravity Model: Probabilities and Market Share Locked
- New Site Selection: Weighted Scoring and a Scatter Map Locked