Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-14-2021, 10:39 AM
MarcusF MarcusF is offline Matching data to the closest latitude, longitude and date Windows 10 Matching data to the closest latitude, longitude and date Office 2016
Novice
Matching data to the closest latitude, longitude and date
 
Join Date: Feb 2021
Posts: 2
MarcusF is on a distinguished road
Default 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!
Attached Files
File Type: xlsx Coral Reef Help.xlsx (234.9 KB, 11 views)
Reply With Quote
  #2  
Old 02-20-2021, 04:12 AM
MarcusF MarcusF is offline Matching data to the closest latitude, longitude and date Windows 10 Matching data to the closest latitude, longitude and date Office 2016
Novice
Matching data to the closest latitude, longitude and date
 
Join Date: Feb 2021
Posts: 2
MarcusF is on a distinguished road
Default

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
Attached Files
File Type: xlsx Coral Reef Help 2.xlsx (229.3 KB, 5 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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
Matching data to the closest latitude, longitude and date 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
Matching data to the closest latitude, longitude and date MS Project Start Dates not matching the Status Date sjodom Project 3 12-04-2011 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft