+ 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
    1

    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 Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,646

    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
    [Fmr 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)

Similar Threads

  1. [SOLVED] Minimum Distance Between Two Lat/Long Points
    By cas8100 in forum Excel General
    Replies: 3
    Last Post: 05-21-2021, 05:15 AM
  2. [SOLVED] Formula to determine distance between 2 points (lat/long)
    By kersplash in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-05-2018, 02:45 AM
  3. Replies: 1
    Last Post: 08-27-2014, 04:30 PM
  4. [SOLVED] Calculating distance between many GPS points and sorting by distance
    By jackalek in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-14-2014, 08:27 AM
  5. [SOLVED] Maximum Distance Between Lat/Long Points
    By scorpion419 in forum Excel General
    Replies: 10
    Last Post: 11-13-2012, 04:48 AM
  6. Excel 2007 : Distance Formula with Lat/Long
    By shedhead in forum Excel General
    Replies: 2
    Last Post: 05-16-2012, 08:19 PM
  7. formula to find distance across points on a grid
    By Powrpak in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-24-2008, 04:35 PM

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