Compare list of Lat Long

[mleikin]

I have a list of 800 lat/long coordinates. I need to see how many of those 800 are within 3 miles of another list of 7,000 lat/long coordinates.

I have found the following formular to find the distance between 2 lat/longs:
=ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *3958.756

Is there a formula that would allow me to run each of the 800 Lat/longs against the list of 7,000 and indicate how many on the original list have a match within 3 miles?

I was thinking a combination of countif with an array formula, but I can get the order of operations correct. Any help?

 

[geospatial]

I know this is an old post, but does anyone have a table for what numbers I would need to calculate different distances. For example 3958.756 is miles, but what about meters, feet, and other calculations?