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!!!