Thanks again for the quick reply. It wouldn't be a problem to return
locations in different cells, so a formula solution for that would be great.
I'll also talk to my IT folks to see if they'll allow me to install the excel
addon you referenced. Looks like a lot of great stuff there.

Toby

"Domenic" wrote:

In article ,
Toby wrote:

Thanks, that looks like it will work, but I'm on a company laptop that blocks
me from installing any software, addons, etc. Is there any other way to do
this within the existing functionality of excel?

Toby

If you don't mind returning the locations in separate cells, I can offer
you an alternative formula solution. Otherwise, if you want them
returned in a single cell, you're going to need a VBA solution. Which
route would you like to take?

--
Domenic
http://www.xl-central.com