•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Longitude and Latitude Comparison
Our take
If you're looking to compare two lists of longitude and latitude data, you're not alone. Many encounter challenges when trying to find the closest location from a second list for each entry in the first. While you already have the formula to calculate the distance between two points, the real task lies in efficiently applying this across nearly 2,000 locations. Engaging with the right tools or programming techniques can simplify this process, enabling you to streamline your search for the nearest coordinates effectively.
I have 2 lists of longitude and latitude location data. I'm trying to find a way to compare the 1st list to the 2nd list and return the closest location from the 2nd list for each on location on the 1st list. I know the formula to get the distance between two long/lat points but I need it to work over a list of almost 2,000 locations. Anyone have an idea how I can accomplish this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#rows.com#natural language processing for spreadsheets#AI formula generation techniques#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#formula generator#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#longitude#latitude#location data