separate the last digit, and detect in the 7 patterns, you will have 3 option of the 7 patterns
low / high, even / odd / and major minor / equal in each position
https://www.excelforum.com/attachmen...1&d=1592837556
separate the last digit, and detect in the 7 patterns, you will have 3 option of the 7 patterns
low / high, even / odd / and major minor / equal in each position
https://www.excelforum.com/attachmen...1&d=1592837556
Would you offer a little more explanation please.
I'm assuming you want to generate the 3 numbers that you show in cells AG10 and to the right. However I don't understand what rules are used to generate the numbers, nor do I know what YOU mean by 'valley', 'repeat'...etc.
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.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
ok sorry, maybe google translates badly
valley = means that a value has been assigned, repeat means
ex == 156
458
repeat that in 2nd position repeat the same
so we have three possible patterns
major minor and equal (equal is when repeats)
ok let's go in stages, let's separate the digits lasts from each number example 17 o 7 o seven is the last digit
ok we have 15 positions, to classify in the 7 patterns, if it is even or odd whether high or low or if it is the patterns = major, minor and equal represented by numbers from 1 to 7, each position will have three patterns, that is to say is represented repeat
want to say that you repeated this attention from the last draw to the next, the base or reference is always from the last draw to the next
hello please!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks