Hi, I use a 3rd party excel plug in called Spheresoft that I use to calculate
distance in zip codes. My question is really a function of excel and not the
tool itself.
In short I have in Sheet1 a list of sites: address, city, state, zip etc.
I have a sheet called techs that list all the name and addresses of my techs.
Basically it looks at the zip code from sheet one and picks the one with the
lowest distance value. Works great.
However..
It would be great if i could have column c be the second closest tech.
Is there a way to have it exclude the tech from column b (which is the
closest), for the purpose of choosing the second closest.
My formula in column B is as follows.
=INDEX(techs!$H$2:$H$12,MATCH(zipcodesinlistwithin distance(Sheet1!I2,techs!$G$2:$G$12,$M$1),techs!$G $2:$G$12,0))
I2 contains the client zip code