Forum Discussion
check if coordinates are within certain polygon
Yes, let's have some tables from you. Preferably in an app (say Excel as a workbook).
I've been working on polygons like this and have (I think) been successful (purely in Power Query) but I won't post my offering (because it's a mess, currently) until I have a good idea of how your data arrives and how you want it to show at the end.
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)?
