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