Help with determining near duplicates in long list of longitude latiude coordinates

[strat919]

This may not be possible, but I have many lists of long lat coordinates. I need to weed out duplicates, but the duplicates do not have exactly the same long lat coordinates, but they are close..... say within 30 feet. Everything is in decimal degrees. I need a way to calculate an entire list so I can tell which coordinates are very close to each other. Any ideas?

Thanks

 

[lrobbo314]

I did a proof of concept test with some GPS coordinates. I used PowerQuery. I added the list of GPS coordinates, duplicated the table, then added a custom column. The first table was called Table1. The duplicate was Table2. In table2, the custom column just referenced Table1, the formula is '=Table1'. This will give you every combination of each location. Then, I followed the instructions from this site to do the math for the distance calculations. The instructions get you distance in miles, but converting to feet is easy enough. Then, you can sort the distance column from low to high to see the locations that are closest to each other.

 

[strat919]

Thanks for your help I will try this