Forum Discussion
Finding closest Clinic from a given postcode
distances are in km.
I cannot upload a spreadsheet with my data however here is a small example:
This would be a list of ALL postcodes (currently 160,000 rows):
| AB25 1HN |
| AB25 2YT |
| AB51 5DD |
| EH39 4HH |
| EH4 7HF |
| EH46 7HZ |
| EH54 7BA |
| EH6 8JL |
| FK2 0TS |
| FK7 9NL |
| G2 6UA |
| G73 3HS |
| G73 5DJ |
| IV18 0AA |
| IV36 1DT |
| IV36 1EQ |
| KY12 8QB |
| ML11 9WQ |
| PA15 2TL |
| PH10 6JQ |
Then this would be my clinics table, which will grow and I will need to add more:
| Clinic Post Code | Name |
| EH3 9AF | EDINBURGH |
| G1 1DQ | GLASGOW |
| AB12 3LF | ABERDEEN |
| DD2 5JT | DUNDEE |
So, when a postcode is entered, it will look to see which clinic is closest from the clinic list and display the name of the clinic and how far it is,
for example if the post code was EH4 7HF then the response would show
CLINIC NAME: Edinburgh
Distance: 4.4 miles
distances are in km.
Wow, thanks.
Now what if I wanted it so that if I just enter a single postcode it will give me a result? Like how you have a table of the results, I will be having over 160k post codes, so rather than a manual search a postcode is just entered
You can have a slicer. It won't be fast but it will work. Personally I would use the filter pane with Advanced filtering.
Do I need to remind you of the KM to Miles conversion factor? What type of mile?
And sorry, is it possible to have the results in Miles or is KM the only option?