Forum Discussion
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 Tabl...
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.
If anyone has any pointer I would love the help.