#1
|
|||
|
|||
Matching data to the closest latitude, longitude and date
Hey everyone,
I'm currently doing a study which compares coral reef cover with changes in temperature across the Great Barrier Reef. I have two big datasets which I'm trying to match together by longitude, latitude and date. I'm trying to match each hard coral cover data point with the temperature value that has the closest sample date, longitude and latitude and then show this temperature value in the 'Closest Temperature Value' column. Can someone help me with this? If this is possible, is it also possible to show the distance and time difference between the temperature value shown in the 'Closest Temperature Value Column' and the hard coral cover value in a separate column? I tried to use the formula shown in this thread, just to match data by longitude and latitude, but even that didn't seem to work and just gave me #N/A for all the results. I've attached my spreadsheet to this post. Thank you! |
#2
|
|||
|
|||
An update on this thread. A friend of mine managed to figure out the formula to match temperature data to coral cover data with the nearest latitude and longitude, but he was unsure of how to add date to the formula. If anyone can add date to this formula, so that each temperature data point is matched to the closest longitude, latitude and date, that would be really great. I've attached his spreadsheet to this post. The formula that my friend made which matches temperature data to coral cover data with the nearest longitude and latitude is in cell J2.
Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Read data on Sheet3 copy to Matching cells on Sheet1 | Potholes | Excel Programming | 2 | 08-21-2019 11:53 PM |
Best formula for matching column data from one workbook into another | awpatts | Excel | 1 | 05-10-2017 06:56 AM |
Convert Longitude/Latitude to Address OR get data from web form | markusbohu | Excel | 2 | 11-18-2016 10:14 PM |
Trying to import specific data from one spreadsheet to another, without matching rows | Wynka | Excel | 0 | 11-26-2014 09:33 AM |
MS Project Start Dates not matching the Status Date | sjodom | Project | 3 | 12-04-2011 08:45 AM |