+ Reply to Thread
Results 1 to 8 of 8

Selecting Data set based on entered longitude and latitude and closest location

  1. #1
    Registered User
    Join Date
    04-27-2012
    Location
    SC USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Selecting Data set based on entered longitude and latitude and closest location

    Hi all,

    New here and have a stumbling question. I have created a spreadsheet with 5000+ rows with several data points including longitude and latitude. My goal is to enter coordinates in decimal form and then have the correct data displayed based upon the closest coordinates in the data set. Any thoughts?

    Example:
    User enter: -73.456 long 41.567 lat

    output results: closest location point and then selected data.

    Thanks,

    J

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Selecting Data set based on entered longitude and latitude and closest location

    Hi Solarj,

    Welcome to the forum.

    This can be achieved using lookup function (index - match)... upload an sample file. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    04-27-2012
    Location
    SC USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Selecting Data set based on entered longitude and latitude and closest location

    Thank you for the reply. Here is the sample file based on locations in the US. There are two sheets, one with the input and the other with the data. Thanks for the help.
    Attached Files Attached Files

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Selecting Data set based on entered longitude and latitude and closest location

    Hi Solarj,

    See the attached file.

    Station TEST.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    04-27-2012
    Location
    SC USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Selecting Data set based on entered longitude and latitude and closest location

    I can't seem to get it to work properly. Ex. I want to enter Lat 32.8 and long -79.84. I would like it to display the nearest station = Charleston Intl airport or folly island.

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Selecting Data set based on entered longitude and latitude and closest location

    Hi Solarj,

    Please highlight few of the selections in Excel which should be the answer as per you and upload the file. I'll try and match up them ... thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  7. #7
    Registered User
    Join Date
    04-27-2012
    Location
    SC USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Selecting Data set based on entered longitude and latitude and closest location

    Thank you! they are highlighted Rows 825 and 828.
    Station TEST.xlsx

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Selecting Data set based on entered longitude and latitude and closest location

    Hi solarj,

    Since we need to do the nearest match on two columns, it would be little difficult to achieve this. If you search 32.8 on Latitude then we can get a match (row 75) but if we look for 32.8 and -79.84 separately, then the nearest match would be two different rows.. thanks.

    I'll get back if any thing clicks in my mind.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ 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