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
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
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]
6string, is the difference of the last digit of a group with the 1st of the other group
ex = .... 05) (06 ..) 5-6 = 1
Put this formula in T5:
Formula: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:Please Login or Register to view this content.
then similar for AL, AM, AN, then fill down.
Formula in Q5:
Then copy formula from Q5 through to AI5. Then copy down to Q6:AI1806.Please Login or Register to view this content.
Formula for AK5:
Then copy formula from AK5 through AN5. Then copy down to AK6:AN1806.Please Login or Register to view this content.
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!
hello, 6string and wedeboy, is corret, conglatutations thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks