GPS Distance

Originally Posted by Muttly

Hi. I have a list of gps cordinates in deciaml format where lat is in column a nad lon is in column b. I have the formula below to determine how far 1 of co-ords is from another. What I need is to get is for column c to say yes if any other location is within 50m. Ideally I'd like for column d to say which row was within the 50m range.

Can anyone help me out please.

=ACOS(SIN(A3)*SIN(A4)+COS(A3)*COS(A4)*COS(B4-B3))*3443.89849

Also, if you're in degree form in regards to your decimal values for your lat and lon values, the formula you have won't work because it is measuring distance in Radians. You'll need to convert, or use a different equation.