+ Reply to Thread
Results 1 to 4 of 4

detect only complete triplets.

  1. 03-30-2023, 09:51 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    detect only complete triplets.

    detect only complete triplets, and in the list on the side, see their frequencies
    how many times each of the 5 trios was drawn
    objective is to see if in 75% to 80% one of the 5 trios is present in the draw, only complete trios
    ex= 01 11 22 can't because it flats 21
    https://www.excelforum.com/attachmen...1&d=1680184248
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-30-2023, 11:16 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: detect only complete triplets. 

    Please Login or Register  to view this content.
    This ???
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 03-30-2023, 11:25 AM #3
    Kaper
    Kaper is offline
    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,623

    Re: detect only complete triplets.

    You can do it also with formulas.

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

    R5 (and copied to S5):
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    then all 3 cells copied to U5:W5, Y5:AA5 and so on

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


    All this formulas copied down.
    Attached Files Attached Files
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  4. 03-31-2023, 04:30 AM #4
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect only complete triplets.

    ok john, kaper, perfect, conglatulations, thank you!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. detect the 10 triplets in the 5 positions .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2022, 02:04 PM
  2. detect only triplets without repeating digits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2022, 04:15 PM
  3. [SOLVED] Only detect matching complete trios on each draw line.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2019, 05:08 PM
  4. [SOLVED] separate the 5 triplets and detect the 8 matching odd / even patterns.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-25-2019, 05:27 PM
  5. Lotto triplets,quads and more
    By dragon66 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-14-2014, 08:46 AM
  6. [SOLVED] Vb code To Find the missing triplets and complete the number series..?
    By sem in forum Excel Programming / VBA / Macros
    Replies: 43
    Last Post: 05-31-2012, 02:48 PM
  7. Pairs, Triplets, Quads...
    By Mike NG in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-05-2005, 09:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1