What formula can I use to get closest city out of a list

[oneal1767]

I have a spreadsheet with a list of customers, city, state, zip. I've inserted a UDF to calculate driving distance from a given starting location and ending location. What I would like to do is use a formula so the spreadsheet will calculate and tell me which city in the list is closest to each one. Is this possible? I'd appreciate any help with this.

The formula I'm using is getGoogDistanceTime(StartLoc,EndLoc,"distance")

Thanks!

[darkyam]

It's probably possible, but we'd need to see a sample of your data, including how you'd like your results. The UDF you created doesn't help us much since only you really know exactly how it works. Also, there will by definition be at least one pair of cities that just lists each other as the closest match and probably several. Do you want all of these pairs listed twice?