+ Reply to Thread
Results 1 to 8 of 8

detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns where

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

    detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns where

    detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns
    where = pp = is pair / pair and ex= = 02, 04,06....
    ii = is odd and odd = 13. 15,17
    ip = odd / even = 12. 14,18...
    pi = even / odd = 03.05,09 ..
    sometimes there will be no trio of each pattern in the first trio of each draw no problem,
    objective is to detect the 1st trio of each of the 4 patterns
    https://www.excelforum.com/attachmen...1&d=1611927688
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns where

    Hi,

    It's not at all clear (at least to me) that I understand all that you're saying. We often find that when we give an answer to what is an uncompleted example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

    Thereforemanually add the results you expect to see for say a dozen different rows. Clearly identify how you have arrived at your results.

    Remember that when you ask a question in a forum those of us who might be able to help know absolutely nothing about your system and work process or the terminology you use. Unless you have uploaded a workbook we know nothing about how it is laid out and little about what you want done with it or how the results should be presented.

    Whilst these things are second nature to you since you live with the workbook all the working day we start with zero knowledge so you need to take us by the hand and explain in quite precise detail your aims and goals as well as stuff like how your data might look different in other situations.
    Don't assume we are able to "figure it out". We're usually quite good but not prescient.

    Put yourself in our position and think about whether what you've posted makes sense and is unambiguous to someone who's never seen it before.
    You are asking us for help so help us to be able to help you by providing all the information we need, even if that information seems obvious or intuitive to you.

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

    Re: detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns where

    ok richard, correct, let's go by parts =
    is a lottery 25-15 where 15 numbers out of 15 are drawn, this is the draw in ascending order,
    objective is to detect the 1st trio in the sequence of the 15 numbers of each draw, the 1st trio only of each of the 4 patterns = pp ii ip pi, with this I will later create a filter, sometimes there will be no trio in each pattern problem,
    pp is even / even
    ii odd / odd
    odd / even ip
    odd and even pi

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,335

    Re: detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns where

    Here is the code. Result in Q9:T10
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 01-29-2021 at 02:22 PM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

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

    Re: detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns where

    hello, kvsrini, almost there, always remember 1st trio, amacro is not executing the other draw lines on the list !, every semester I will put new drawings, because amcro does not execute the other lines on the list?

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

    Re: detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns where

    hello KVS error there is no number 15 !!! in this draw, 11 13 15 = 15 error
    sometimes there will be 3 digits in the standard of the trio that this case only has 11.13, where did you get the 15 ???

  7. #7
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,088

    Re: detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns where

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: detect only the 1st trio of each of the 4 pp, ii, ip, pi patterns where

    ok hum! hello BORY ,very good work, bo-ri, work of art, conglatulations !!! note how the trio varies in the 4 patterns, it was great congratulations, thanks

+ 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 that are in 4 colors in each position.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2020, 03:40 PM
  2. [SOLVED] detect in each position the 4 patterns with the corresponding colors.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-02-2020, 10:03 AM
  3. separate the last digit, and detect in the 7 patterns.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2020, 10:39 AM
  4. [SOLVED] separate the last digit, and detect in the 4 patterns the sum of each
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-16-2020, 08:49 AM
  5. detect the 4 patterns only **
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2019, 12:08 PM
  6. [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
  7. [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

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