+ Reply to Thread
Results 1 to 5 of 5

detect on pick3 from 000 to 999 where you have the doubles increasing in any position .

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

    detect on pick3 from 000 to 999 where you have the doubles increasing in any position .

    detect on pick3 from 000 to 999 where you have the doubles increasing in any position
    the macro will separate in a list next to the 1000 (thousand) formations only those where the growing pair is present and its inverted does not matter the position, please
    01 12 23 34 45 56 67 78 89 09
    ex=
    156 = 56 is increasing, yes
    157 = no double crescent
    https://www.excelforum.com/attachmen...1&d=1560945364
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: detect on pick3 from 000 to 999 where you have the doubles increasing in any position

    Does this work in E6 and copied down?

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

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

    Re: detect on pick3 from 000 to 999 where you have the doubles increasing in any position

    hello WIDE Can you get on the sheet? please

  4. #4
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: detect on pick3 from 000 to 999 where you have the doubles increasing in any position

    Here it is on the sheet. Not very complex though ...

    WBD
    Attached Files Attached Files

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

    Re: detect on pick3 from 000 to 999 where you have the doubles increasing in any position

    ok, WIDE, perfect, conglatulations, 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] decree each lottery pick3 in its default well we have 27 patterns in 1oo%
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2020, 08:36 AM
  2. Replies: 4
    Last Post: 03-18-2019, 02:34 PM
  3. 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
  4. pick3 converter 6 patterns
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2016, 07:50 PM
  5. How to Detect Changing of the workbook screen position
    By recorded in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2015, 05:24 PM
  6. Formula to detect if row values are increasing?
    By AntiPivotTable in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-08-2015, 06:11 PM
  7. [SOLVED] Sine wave with increasing peaks and increasing troughs
    By JimDandy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-18-2013, 06:28 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