Hi all,
Do you know if there is a way to have a source Post-Code (Example AB10 1HW) then have a formula that looks down a list of other postcodes and finds the closest possible to the source?
I wasn't sure if Excel 2016 has features like that?
Cheers
Steve
Do you know if there is a way to have a source Post-Code (Example AB10 1HW) then have a formula that looks down a list of other postcodes and finds the closest possible to the source?
I wasn't sure if Excel 2016 has features like that?
Cheers
Steve