+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    02-26-2019
    Location
    NH
    MS-Off Ver
    360
    Posts
    6

    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
    Last edited by GCarpenter; 02-27-2019 at 01:56 AM. Reason: cross-posted

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,056

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

    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
    Cheers,
    Paul Edstein
    [MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1