+ Reply to Thread
Results 1 to 7 of 7

detect the string with the three digits of pick3.

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

    detect the string with the three digits of pick3.

    detect the string with the three digits of pick3
    two digits or one is not worth only three digits
    Of course, the draw of pick3 that has 10 twin pairs 00 ..99 is not worth only pick3 without repetition
    https://www.excelforum.com/attachmen...1&d=1633055604
    Attached Files Attached Files

  2. #2
    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,650

    Re: detect the string with the three digits of pick3.

    A proposition with formula, not a macro.

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


    Copy down and right under each heading, so into columns K; O; S; etc.

    Note that F5, J5 etc have to contain text 01, not just 1 formated with leading 0. So write there '01 (apostrophe and 2 digits)
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    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,650

    Re: detect the string with the three digits of pick3.

    Or another formula working independently of shown above (it is already included in the attachment - in AU6:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Again - texts are needed so in AW you shall have
    '012345
    '014567
    etc.

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

    Re: detect the string with the three digits of pick3.

    kaper almost there, we have a problem,
    example 845, we have 3 different digits
    45 is in a group and 8 in another the macro has to catch this too
    kaper!! purpose of this = is to see the pick3 of the three digits
    different doesn't matter if a pair is in the same
    cell, has to coordinate this,
    the macro just doesn't read the twin doubles example 445
    don't need or 555,
    only pick3 with different digits doesn't matter
    if a cell has the duo, doubts?

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

    Re: detect the string with the three digits of pick3.

    kaper we have a problem the macro did not detect pick 3 879! why
    because two digits are in the same cell you need to correct
    8 7 9 must be marked
    other pick 3a where two digits are in the same cell the macro does not detect it has to correct

  6. #6
    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,650

    Re: detect the string with the three digits of pick3.

    So your sample file in first post was worthless.
    Already in first row there shall be
    01 45 67
    23 45 67
    45 67 89
    marked for the pick
    4 6 5

    Please prepare your sample files carefully


    My proposition of formula in G6 (and other cells):
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: detect the string with the three digits of pick3.

    hello KAPER!! perfect! congratulations, great work on the 6 digit strings, when you win a prize will be rewarded, 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 number of times that pick3 occurred in the green list.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-26-2020, 04:02 PM
  2. [SOLVED] detect trios without repetition of digits, that is, with 6 distinct digits.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-15-2020, 08:49 AM
  3. [SOLVED] help in excel, detect the largest and smallest digit of pick3 zero is the smallest digit *
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-13-2020, 06:14 AM
  4. Replies: 2
    Last Post: 09-20-2019, 11:13 AM
  5. [SOLVED] detect on pick3 from 000 to 999 where you have the doubles increasing in any position .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2019, 08:55 AM
  6. [SOLVED] please, detect trios without repetition of digits or with 6 different digits.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-23-2019, 11:03 AM
  7. please detect the front double of the pick3 and see the amount of each groups.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2019, 10:01 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