Multiple Location plotting within radius

**bedwards91** · 07-10-2018, 10:12 AM

Hi,

New here but hopeful someone will have a solution!

I'm looking at creating a workbook which will automatically give me the information of all locations within the desired radius.

There are 3838 locations which will be constant, however I'll need to calculate how many of these locations are within an 'x' mile radius of other locations. (the second locations will vary based on my client requirements)

So far I've put together a sheet which calculates the closest possible location only, which is a start but ideally I need to know all points within 'x' miles.

Any suggestions welcome.

thanks

B

**dflak** · 07-11-2018, 10:36 AM

I'm a bit fuzzy on the requirement. I'll explain what I think it is and you can tell me where I went wrong.

Let's look at ROSE SUPERMARKET. You want to look at all the customer locations and compute a string of them where the customer location is within 50 miles. The results would look like OTS1, OTS6, OTS9 - with real names, of course.

If this is so, would you have an objection to having the customer locations in a separate table from the Main Table?

**dflak** · 07-11-2018, 12:01 PM

I did a bit of reverse engineering and reread the OP. I think this is more along the lines of what you want. You want every OTS POSTCODE within 50 miles of the OTS POSTCODE for any given row.

Specify the radius (in miles) that you want in Cell C1. I specified a half mile and I still got more replies than I could handle. I haven't checked, but I think every Post Code is within 50 miles of every other Post Code.

Warning, there are 3838 Lines and each of these have to loop against 3838 lines - that's a bit shy of 15 million calculations. The code runs a bit slow.