Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI started this quite awhile ago before I really knew spatial tools. Used it as practice to make a batch macro (create a table with all values), then never finished the workflow. Picked it back up again now that I have studied the spatial tools and reworked to the finished solution. I did get far enough with the macro solution that it would have given the same answer.
Solution attached
Good exercise. Betting there are simpler ways, but I am learning more and more about spatial tools (no pun intended)