+ Reply to Thread
Results 1 to 8 of 8

Nearest neighbour limited by point type

Hybrid View

  1. #1
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,873

    Re: Nearest neighbour limited by point type

    Sure, not Q but M. Good you spotted this
    So if O and P are some mesurements (this is how I understand coordinates) in 2 perpendicular directions, I'd for sure recommend

    (O2-O$2:O$1000)^2+(P2-P$2:P$1000)^2
    (twice)

    have a look on
    0 0
    and
    0 5
    5 0
    3 3
    The closest one to 0,0 will be 3,3 (some 4.25 units away)
    Best Regards,

    Kaper

  2. #2
    Registered User
    Join Date
    05-26-2013
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    79

    Re: Nearest neighbour limited by point type

    You are absolutely right, I just worked that out as you replied

    Will definately use cartesian and have ammended this already. And as you previously mentioned SQRT is not required, which makes sense. This formula is working perfectly now and will save me hours.

    Thanks for your help, I will now mark this as solved

+ 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] Return the difference between a value and it's nearest upper and lower neighbour?
    By Prince Dakkar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-10-2013, 07:21 PM
  2. [SOLVED] Scatter Plot X Axis to the nearest point
    By vcodec in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-07-2012, 09:57 AM
  3. Using Large Point Type Over Two Rows
    By scotfitz in forum Excel General
    Replies: 3
    Last Post: 11-06-2010, 02:30 PM
  4. Replies: 4
    Last Post: 10-31-2010, 09:37 PM
  5. Rounding to the nearest quarter point?
    By George in forum Excel General
    Replies: 3
    Last Post: 06-10-2006, 05:15 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