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

[jorel]

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

[Richard Buttrey]

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.

[jorel]

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

[kvsrinivasamurthy]

Here is the code. Result in Q9:T10

Please Login or Register  to view this content.

[jorel]

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?

[jorel]

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 ???

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[jorel]

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