Data Sorting Question: Split by 'Nearest to a specific location'

Hi there,
Apologies if this post in the wrong place, I hope someone can help.

I have a database of names, email address and postcodes for a chain of 5 hotels and I would like to segment the data to add a 'nearest to X Hotel' column, thus allowing me to filter the names by 'nearest hotel'.

I've searched the net and can't find anything that can do this, ideally it would be a simple macro or script to add into my excel database.

Any help would be massively appreciated.


Mathew Mathew, 7 years ago

I know these products do exist, because I've seen them used in other places before, but unfortunately I can't recall a specific one for you. Perhaps someone else can?

Get in touch with us on Twitter:
We're also on Facebook:

See why 200,000 companies worldwide love Campaign Monitor.

From Australia to Zimbabwe, and everywhere in between, companies count on Campaign Monitor for email campaigns that boost the bottom line.

Get started for free