Hi,Hi guys,
I need some help with a formula that calculate the distance from point A to different points B C D E F G using lat and lon and show the closest one.
Please find an example attached.
Thank you very much for your help.
Don't mention itThat's brilliant. I didn't think to use Index and Match.
Thank you so much.