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.
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)?
