+ Reply to Thread
Results 1 to 9 of 9

separate the 5 triplets and detect the 8 matching odd / even patterns.

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

    separate the 5 triplets and detect the 8 matching odd / even patterns.

    separate the 5 triplets and detect the 8 matching odd / even patterns.
    then see how many times each of the 8 patterns within the 5 cracks was drawn
    * An example
    * 211 = has been drawn x times, is the quantity of each pattern
    https://www.excelforum.com/attachmen...1&d=1564062445
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: separate the 5 triplets and detect the 8 matching odd / even patterns.

    I don't know if I'm correctly interpreting your request, but you can identify whether each number is odd/even using the following in Q5:

    =MOD(A5,2)+1

    Copy it right through AI5, adjusting for the triplets, then fill down.

    You can then use COUNTIFS to count the number of times each triplet combination has been drawn using the following in AM5:

    =COUNTIFS($Q$5:$Q$1836,LEFT(AK5,1),$R$5:$R$1836,MID(AK5,2,1),$S$5:$S$1836,RIGHT(AK5,1))+COUNTIFS($U$5:$U$1836,LEFT(AK5,1),$V$5:$V$1836,MID(AK5,2,1),$W$5:$W$1836,RIGHT(AK5,1))+COUNTIFS($Y$5:$Y$1836,LEFT(AK5,1),$Z$5:$Z$1836,MID(AK5,2,1),$AA$5:$AA$1836,RIGHT(AK5,1))+COUNTIFS($AC$5:$AC$1836,LEFT(AK5,1),$AD$5:$AD$1836,MID(AK5,2,1),$AE$5:$AE$1836,RIGHT(AK5,1))+COUNTIFS($AG$5:$AG$1836,LEFT(AK5,1),$AH$5:$AH$1836,MID(AK5,2,1),$AI$5:$AI$1836,RIGHT(AK5,1))

    Fill down for the other trios. Take a look at the attachment to see if I'm understanding your objective correctly:
    Attached Files Attached Files
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html

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

    Re: separate the 5 triplets and detect the 8 matching odd / even patterns.

    ok,CAntosh perfect, great job. congratulations.
    thanks for the great work

  4. #4
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: separate the 5 triplets and detect the 8 matching odd / even patterns.

    My pleasure, good luck!

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

    Re: separate the 5 triplets and detect the 8 matching odd / even patterns.

    hello Can, I know it's marked as solved but you can do it
    on the low = 0,1,2,3,4 high = 5,6,7,8,9
    low valley = 3 high = 4
    * the previous one was made even / odd
    now in the same base mold /
    * high
    * ex = 343.

  6. #6
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: separate the 5 triplets and detect the 8 matching odd / even patterns.

    I'm not sure I understand. Could you post a new sample workbook with an example of how it should look?

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

    Re: separate the 5 triplets and detect the 8 matching odd / even patterns.


  8. #8
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: separate the 5 triplets and detect the 8 matching odd / even patterns.

    Thank you for the clarification! Same idea as before, but use the following to return your 03/04 score:

    =IF(RIGHT(A6,1)+0<5,3,4)
    Attached Files Attached Files

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

    Re: separate the 5 triplets and detect the 8 matching odd / even patterns.

    ok CAntosh,perfect, 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. [SOLVED] detect the 4 patterns * after separating the last digit
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-21-2019, 10:38 AM
  2. detect the 3 patterns, bigger smaller and equal with the colors.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-15-2019, 07:10 PM
  3. separate last digits, and sort the 4 patterns and sums
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-03-2018, 01:30 PM
  4. please separate the formations from each of the corresponding 16 patterns .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2018, 03:09 PM
  5. [SOLVED] Please separate the first 4 last digits and rank in the 24 patterns.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2018, 05:40 PM
  6. [SOLVED] separate odd and even training in the 8 patterns
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2018, 12:08 PM
  7. Verify matching patterns between two columns
    By okanem in forum Excel General
    Replies: 2
    Last Post: 04-21-2010, 03:33 AM

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