+ Reply to Thread
Results 1 to 6 of 6

calculate the delta values (distances) between the trios .

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,169

    calculate the delta values (distances) between the trios .

    calculate the delta values (distances) between the trios
    goal is to have the suit of 4 distances between the suits
    https://www.excelforum.com/attachmen...1&d=1560812536
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: calculate the delta values (distances) between the trios .

    You have to define what you mean by "delta values (distances) between the trios". It is not at all clear where you got the numbers

    Please Login or Register  to view this content.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,169

    Re: calculate the delta values (distances) between the trios .

    6string, is the difference of the last digit of a group with the 1st of the other group
    ex = .... 05) (06 ..) 5-6 = 1

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: calculate the delta values (distances) between the trios .

    Put this formula in T5:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and then Copy, Paste Formula to X5, AB5, AF5

    Then fill down each column.

    in AK5

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    then similar for AL, AM, AN, then fill down.

  5. #5
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: calculate the delta values (distances) between the trios .

    Formula in Q5:

    Please Login or Register  to view this content.
    Then copy formula from Q5 through to AI5. Then copy down to Q6:AI1806.

    Formula for AK5:

    Please Login or Register  to view this content.
    Then copy formula from AK5 through AN5. Then copy down to AK6:AN1806.

    Unable to attach a reference as it's now too big :-|

    WBD
    Last edited by WideBoyDixon; 06-18-2019 at 11:47 AM.
    Office 365 on Windows 11, looking for rep!

  6. #6
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,169

    Re: calculate the delta values (distances) between the trios .

    hello, 6string and wedeboy, is corret, conglatutations thank you

+ 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. I want to find the closest point to the origin using delta X and Delta Y.
    By dcmapper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2016, 05:05 AM
  2. How do I calculate distances between postcodes
    By mjones10 in forum Excel General
    Replies: 2
    Last Post: 01-14-2016, 09:27 AM
  3. VBA Formula to Calculate Distances with Google Maps API
    By Tonan230 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-25-2015, 07:25 PM
  4. How to calculate distances between two cells in VBA?
    By gerotutu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2015, 04:53 AM
  5. Replies: 2
    Last Post: 02-12-2015, 11:59 AM
  6. [SOLVED] Calculate angles and distances from XYZ-points
    By Giake in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-27-2014, 09:23 PM
  7. Using google to calculate distances… in a macro
    By fosters_ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2014, 03:37 PM

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