first time poster, and amateur excel user, so sorry if this is covered elsewhere.
I have a series of inter-related coordinates on a grid (these are monitoring stations and sample plots...I want to be able to figure out which plots are within certain distance of the stations - we have about 100 departments (with 3-4 stations each) and literally hundreds of sample plots that change quarterly).
So I already know how far it is from the stations to each point , but I want to then take this information and auto-build a list for each of my locations. So each year we could just plug in the new sample plot coordinates and it would auto generate a list for each station showing which plots to check.
I've got the distance calc figured out (using a simple distance equation) like this:
Name Dist1 / Dist2 / Dist3
Boaz 456 / 17 / 43
Strom 98 / 802 / 80
so from the example I know that Boaz is 456 units away from point1, 17 from point2, 43 from point3.
Or put in the way that we need the info, we know that station 1 is 456 units away from Boaz, and 98 units away from Strom.
Now here's where I am stuck. I'd like to have another table/pivot(?) where I can distinctly list all points that are less than 100 units away from my stations. So for my first station table, it would only list Strom (at 98 units away); and my second station table would list Boaz (at 17 units away) as well as then Table3 would list both names (at 43 and 80 units away respectively).
I can paste and sort, but it seems so crude (and time consuming, there are hundreds of named plots). Is there a way for me to make each distance list out on another sheet all named plot points that are less than say 100 units away?
thanks in advance for any help!!!
Bookmarks