See this web site. It looks like the formula would be very easy to put into
Excel
http://www.pjenkins.co.uk/blog/index...e_calculation/

Tyro

"keithobro" wrote in message
...
Hello

At work I have an Excel worksheet containing the UK Postcodes of
candidates.
We have 6 centres at which we run interviews. I want to calculate the
distances between a candidate's home and each of the 6 centres in order to
ascertain which is closest.

Does anyone know of a way of performing this calculation through Excel, or
of a piece of software that would achieve this, without massive cost?

Thanks.

Keith Brooker