Forum Discussion

lucaspayton's avatar
lucaspayton
Copper Contributor
Mar 22, 2022

Distance

Hey, I am trying to find a way to see all the locations that are not within a mile radius of each other. I have longitude and latitude. Is there a way to do this in excel? I was able to do it in Tableau but it was super slow.  

excel
Formulas and Functions

1 Reply

  • lucaspayton's avatar
    lucaspayton
    Copper Contributor
    Mar 30, 2022
    Update I think I am almost there. For longitude I have this formula =IF(ABS(E3-E4)>0.0188, "Yes", "No") and for latitude I have =IF(ABS(F1-F2)>0.0145, "Yes", "No"). For some reason latitude is not working correctly. I have a place in Indiana and Ohio and it states that closer than a mile.
    If anyone has any pointer I would love the help.