RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Let's say you have 1,400 postcodes that correspond to a point on a map. Using a location local(ish) to me, in the UK I have 615 locations across England. I want to find the nearest three for each of the 615 locations, in that same list.
So as an example we choose Gloucester. Geographically near Gloucester in my list of 615 addresses, we have Cheltenham, Stroud, Tewkesbury, and then further afield are Cirencester, Ross-on-Wye, Ledbury.
The closest three are Cheltenham, Stroud & Tewkesbury and I would like this to be reflected. The only information I have is postcode, so this would need to link in to mapping functionality somehow. I'm just wondering if anyone does anything similar and whether this technique is used in anyone's existing processes.
Thanks!
So as an example we choose Gloucester. Geographically near Gloucester in my list of 615 addresses, we have Cheltenham, Stroud, Tewkesbury, and then further afield are Cirencester, Ross-on-Wye, Ledbury.
The closest three are Cheltenham, Stroud & Tewkesbury and I would like this to be reflected. The only information I have is postcode, so this would need to link in to mapping functionality somehow. I'm just wondering if anyone does anything similar and whether this technique is used in anyone's existing processes.
Thanks!