I have a similar list of places (E.g. place names and addresses) and, when looking at the details of one specific location I want to be able to add an in-line list that also shows ‘nearby’ places, where the other ‘nearby’ places are from the same list. For instance filter the in-line list of nearby places to within 4Km of the address of the place details being show.
Do you know how I could go about this? Is it a relation to itself and then pull in addresses and have a distance column? I have tried this but can’t work out how to do the relation part!
Thank you Robert for your great video, it really helped.
From my experience the zip code needs not to be in the same table because the Single Value function can also work with values from other tables.
I’ve also realised, that if you want to calculate a distance with 4-digit zip codes (as we have them in Austria), the calculated values are wrong, but it works great if you add a city name to the zip code.
Excel has a way of interpreting zip codes into coordinates as well as states, counties, countries, cities, etc. just put the list in excel and click the geography button as the column is highlighted and it will do the rest.