+ Reply to Thread
Results 1 to 7 of 7

please, separate into a list * the formations, whose sum of two digits has the sum .

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

    please, separate into a list * the formations, whose sum of two digits has the sum .

    please, separate into a list
    * the formations, whose sum of two digits has the sum of a third digit
    explain = in pick4 we have 10, il formations, there are formations in which
    * in the 4 positions the sum of two digits is the total ex
    3548 = we have 3 + 5 = 8 358, the fourth digit is out of the study
    * well we have 4 positions
    separates this pattern from a list next to the 10 thousand in the
    another example =
    3415 = 4 + 1 = 5. 415
    other 7209 = 7 + 2 = 9,729
    then these and others equal in the sum of two of the four digits
    * result in a third your sum, separate in a list, please
    https://www.excelforum.com/attachmen...1&d=1535630342
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: please, separate into a list * the formations, whose sum of two digits has the sum .

    If I understand correctly the following may help:
    Column B is populated using: =(VALUE(LEFT(TEXT($A5,"0000"),1))+VALUE(MID(TEXT($A5,"0000"),2,1)))=VALUE(MID(TEXT($A5,"0000"),3,1))
    Column C is populated using: =(VALUE(LEFT(TEXT($A5,"0000"),1))+VALUE(MID(TEXT($A5,"0000"),2,1)))=VALUE(MID(TEXT($A5,"0000"),4,1))
    Column D is populated using: =(VALUE(LEFT(TEXT($A5,"0000"),1))+VALUE(MID(TEXT($A5,"0000"),3,1)))=VALUE(MID(TEXT($A5,"0000"),4,1))
    Column E is populated using: =(VALUE(MID(TEXT($A5,"0000"),2,1))+VALUE(MID(TEXT($A5,"0000"),3,1)))=VALUE(MID(TEXT($A5,"0000"),4,1))
    Column F is populated using: =OR(B5=TRUE,C5=TRUE,D5=TRUE,E5=TRUE)
    A filter is then applied to column F showing only the TRUE values and thus the list of values in column A that meet the criteria.
    Note that columns B:F could be moved and/or hidden for aesthetic purposes.
    If I have misunderstood please provide an example of what you would like to see.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: please, separate into a list * the formations, whose sum of two digits has the sum .

    You can also make your formulas more efficient by removing unneeded VALUE function.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

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

    Re: please, separate into a list * the formations, whose sum of two digits has the sum .

    hello jetemec,alkey good job, almost there,
    * the macro has to see, in the 4 positions, always 3 digits
    * where two of them plus the value of the third digit
    * ex = 3729 = 7 + 2 = 9,729
    * Another example
    4268 = 4 + 2 = 6 426
    * note that two digits dictates the third digit by the sum of the two digits, so the question is to filter inside the pick4 10000
    * all patterns in which the sum of two digits has the third total, the 4th digit does not enter the study

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: please, separate into a list * the formations, whose sum of two digits has the sum .

    If I understand correctly you only want to identify were the sum of numerals one and two equals numeral three, the sum of numerals one and two equals numeral four and the sum of numerals two and three equals numeral four. If that is the case, using AlKey's formula paste the following in
    B5: =(--LEFT(TEXT($A5,"0000"),1)+MID(TEXT($A5,"0000"),2,1))=--MID(TEXT($A5,"0000"),3,1)
    C5: =(--LEFT(TEXT($A5,"0000"),1)+MID(TEXT($A5,"0000"),2,1))=--MID(TEXT($A5,"0000"),4,1)
    D5: =(--MID(TEXT($A5,"0000"),2,1))+MID(TEXT($A5,"0000"),3,1))=--MID(TEXT($A5,"0000"),4,1)
    E5: =OR(B5=TRUE,C5=TRUE,D5=TRUE)
    Select B5:E5 and double click the fill handle to copy down,
    Delete column F,
    Filter using column E.
    Let us know if you have any questions.

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

    Re: please, separate into a list * the formations, whose sum of two digits has the sum .

    hello, jete almost there,
    * objective is = to filter all formation in which it has three digits transiting in the 4 positions of the pick4,
    * whose two-digit sum results in the value of the third digit
    * ex =
    1263, 1 + 2 = 3 123 = valid
    1597 = not valid, exclude from the list, because, adding any of the double digits does not result in the third sum value

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: please, separate into a list * the formations, whose sum of two digits has the sum .

    When you say any does that include the sum of the third and fourth digits equaling either the first or second digit? Also the sum of the second and third digits being equal to the first?

+ 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] Separate quartet formations without repetition of digits deleting duplicates .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-01-2018, 04:26 PM
  2. [SOLVED] Separate triad formations without repetition of digits, *
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-05-2017, 08:15 AM
  3. Locate suit formations after typing the desired digits in a field
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 49
    Last Post: 11-12-2017, 05:52 AM
  4. Request = exclude cracking formations with duplicate digits .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-03-2017, 05:28 AM
  5. [SOLVED] Remove formations with duplicate digits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2017, 12:00 PM
  6. separate formations with duplicate digits, please
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2016, 05:08 PM
  7. Formations of 6 digits in ascending order
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2014, 02:11 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