Find value corresponding to 2 values

  • Thread starter Thread starter deligtvoet
  • Start date Start date
D

deligtvoet

Goodmorning everyone,

I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?
Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.

In the best possible way, I would like to find the, say 5, closest points to the given point. So I could get an average value.

Anyone with advise of help please?

Excel-file downloadable from:
http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls

Thanks in advance!
Kind regards
 
Goodmorning everyone,



I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?

Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.



In the best possible way, I would like to find the, say 5, closest pointsto the given point. So I could get an average value.



Anyone with advise of help please?



Excel-file downloadable from:

http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls



Thanks in advance!

Kind regards
Click to expand...
 
Goodmorning everyone,



I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?

Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.



In the best possible way, I would like to find the, say 5, closest pointsto the given point. So I could get an average value.



Anyone with advise of help please?



Excel-file downloadable from:

http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls



Thanks in advance!

Kind regards
Click to expand...

There are difrent ways of giving grid references can you give us the values?
 
There are difrent ways of giving grid references can you give us the values?
Click to expand...

The values are all in the public dropbox link. Collumn A and B are the Easting and Northing Coördinates, while the depth is in C. These are the recorded points, this however is way too much data. I just need the points given in collumn F (name), with their coördinates in G and H. If possible, more values, to get an average depth.

Thanks for the quick respons
Kind regards,
Niels
 
Goodmorning everyone,



I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?

Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.



In the best possible way, I would like to find the, say 5, closest pointsto the given point. So I could get an average value.



Anyone with advise of help please?



Excel-file downloadable from:

http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls



Thanks in advance!

Kind regards
Click to expand...

I didn't look at your spreadsheet, but if you want to find the closest point to another point you would have to calculate the distances from all otherpoints to that point and then select the smallest distance. This is easily done in Excel.
 
Thanks, this returns good data!
I calculated the distance between the points (in km), now I've found the 10smallest values, underneath the data (starting from D8957), but now I needto find the corresponding depth. I inserted the depth in between all the collumns. I used =VLOOKUP(D8957;D$2:E$8956;2) to find the corresponding depth, but it returns #N/A...
Any suggestions?
The file is in:
http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls
 
Goodmorning everyone,



I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?

Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.



In the best possible way, I would like to find the, say 5, closest pointsto the given point. So I could get an average value.



Anyone with advise of help please?



Excel-file downloadable from:

http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls



Thanks in advance!

Kind regards
Click to expand...

I've found the error, the data was unsorted.
Thanks for the early respons all!
 
Back
Top