Calc distance between point and nearest point of defined group of points (UTM coords)

[dridlebert]

Hey folks,

I'm struggling with determine the minimum distance between a point (defined by two UTM coordinates in meters = north and east) and a group of points (each point also defined by two coordinates).

Assuming a plane surface and neglecting the earth's curvature, I can calculate the distance to the geographic center of the group of points by averaging the north and souths coordinates.

I uploaded an example illustrating above.

Any idea would be helpful.
Thanks

[AliGW]

Please tell us what results (values) you are expecting and why.

[dridlebert]

For each point outside the group I want to calculate the distance in meters to the nearest point of the group. This is required to ultimately filter out all points outside the group which are located further than X kilometer. My current method (checking vs. the group's center) is too inaccurate as the spread/dimension of point of the group varies.

[AliGW]

VALUES (numbers), please!

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	D	E
10	7583.2	Value expected?
11	7650.9	Value expected?
12	8392.4	Value expected?
13	8039.7	Value expected?
14	6835.4	Value expected?

Sheet: Sheet1

[nick.williams]

Try this in E10:

=MIN(SQRT((B10-FILTER($B$4:$B$14,$A$4:$A$14="Part of group"))^2+(C10-FILTER($C$4:$C$14,$A$4:$A$14="Part of group"))^2))

[dridlebert]

Perfect, that was exactly what I was looking for. I double checked the results with a GIS. Thanks nick!