Forum Discussion
Solved
check if coordinates are within certain polygon
Hi, I have two tables: Table 1 contains all X Y coordinates Table 2 contains the polygon shape file coordinates, I want to check which coordinates are within the polygon.
Hi p45cal ,
That's exactly what I want. My data is huge, attached is a sample of it. I have two tables, the polygon X&Y is in sheet "Polygon", the data point is in another sheet "Points". A new column "IN/OUT" in sheet "Points" is calculated with 0 if out, 1 if in.
unfortunately, I can't upload the file, here is a snapshot.
My data is huge,
<snip>unfortunately, I can't upload the file, here is a snapshot.
1. Upload it to a file sharing site or onedrive, dropbox, box.com, googledrive etc. there are loads of them, and drop the link to it here.
If it contains sensitive info delete all unnecessary sheets and just supply two tables on two sheets. Pictures aren't much use.
2. Does it have to be Power Query? Could it be a custom user-defined function in vba (a macro)?
