Formula Help Involving Comparing Distance With Lat. Long. Reference Points

(SOLVED) - I apologize for cross-posting - did not know rule until too late.

Hello Everyone,

I'm stumped on this one...

Would anyone know a formula that would return the values shown in the example attached?

I'm trying to find out how many people live within 25 miles and within 50 miles of a store, but my reference points are lat.long. coordinates.

Any help would be greatly appreciated!

Thanks

example.jpg

Cross-posted at:
https://www.mrexcel.com/forum/excel-...ce-points.html
http://www.msofficeforums.com/excel/...tml#post138976
Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html