Formula (or Macro) to caculate if one property is within a 5 mile radius of another?

[tonywatsonhelp]

Hi Everyone,
Not sure if this is possible but I have a list of propertys I downloadd every day.
there location is show in Longatude and latatude.

I want to know how many are within a 5 mile radius of my Home. also in

in Longitude and latitude.

So the ideal solution would be two formulas.

1. that I use in Sheet "Home" that tells me How many Are within 5 miles of my home (in cell H3) the long & Lat is in D3 like this "

34.0843739, -117.602602" (both pages)​

_{^{<strike>
</strike>}}​

It it would be
A
My Home,
D3 Long and Lat
H3 Result of counting number of properties in sheet "Props" that have long and Lat in Column D3 that is within 5 miles of the long & lat of Sheet "Home" Cell D3

Please help if you can.

 

[Macropod]

Try:
=ACOS(SIN(RADIANS(Lat1))*SIN(RADIANS(Lat2))+COS(RADIANS(Lat1))*COS(RADIANS(Lat2))*COS(RADIANS(Long1-Long2)))*RadiusEarth
Where Lat1, Long1 are the lat/lon of, say, your home, and Lat2, Long2 are the lat/lon of the other property. For RadiusEarth you can use 6367.465km or 3956.559mi, being the average of the distances around the equator and poles. Near enough for most purposes.

When mixing hemispheres, enter Northern and Western coordinates as positive, and Southern and Eastern coordinates as negative.

 

[tonywatsonhelp]

THank you Macropod.

This is a big help

Thanks

Tony