detect the three patterns at each pick3 position
in each position it is possible to have , greater, lesser and medium, ex = 495 , greater is 9 and lesser 4 digit 5 is the medium
in twin pairs there is no medium
ex 155= minor 1 major 5 has no medium
in the 10 trios 000.. 999, you don't need to do it
every week I will put new draws
https://www.excelforum.com/attachmen...1&d=1638552145
hello please!
always bumping with the same question
This is a detail in a larger question. What is the purpose ?
Last edited by bsalv; 12-04-2021 at 04:22 AM.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
hello ,Bsalv! great job, the objective is to create filters for pick3 where it is located in the vertical position, which of the positions will have the largest and smallest digit, the third logically being in the middle, for example if you choose the largest digit in the 3rd position, the digit 7 and smaller in the 2nd position 4 logically the average digit is between 5.6, to choose = 4,5,7 or 4,6,7 5,6 are the average
can you see where the smallest digit is most drawn? which of the three positions can improve the map?
you're too close to the problem, step back 2 metres and look from that distance.
Reformulate your problem, because what you ask makes no sense for us.
You do something every week, x draws.
make a sheet with you starting position.
Then you do a lot of manual actions to achieve a goal.
make a second sheet with that goal.
post it here.
HELLO , Bsalv. ok
https://www.excelforum.com/attachmen...1&d=1638622077
I do not understand what you want. However, I have made a guess for columns E to H.
Variants of this:
=REPT("X",SUM(--ISEVEN(FILTERXML("<A><B>"&SUBSTITUTE($A5&" "&$B5&" "&$C5," ","</B><B>")&"</B></A>","//B"))))
Anywhere close??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
And another guess, in I5 copied across and down:
=IF(A5=MIN(FILTERXML("<A><B>"&SUBSTITUTE($A5&" "&$B5&" "&$C5," ","</B><B>")&"</B></A>","//B")),"S",IF(A5=MAX(FILTERXML("<A><B>"&SUBSTITUTE($A5&" "&$B5&" "&$C5," ","</B><B>")&"</B></A>","//B")),"L","M"))
ok glenn, very good job, conglatulations, artwork,
purpose is to filter pick3. by the 4 patterns and crossing with greater and lesser digit transiting within the 3 positions, if I know which one is greater and lesser digit it makes it easier to choose the medium digit (3 digit missing)
Sorry, I do not understand your explanation. SHOW ME exactly what you want for several rows, not just one. LEAVE OUT all irrelevant cells.
Or... explain in detail in Portuguese (Google translate might help me).
I am leaving now, for an hour or so.
EX = GOAL = find the 1st digit of pick 3, the 1st digit can be larger, smaller or medium if correct the 1st digit is halfway to the correct answer
Show me. On a sheet. As requested.
number of times it was drawn
I type it in 1st position, if you have any ideas
of filter for the 1st position of pick 3 you can place at will.
https://www.excelforum.com/attachmen...1&d=1638628808
???
=countif($a$5:$a$18,j5)
Hi Jorel,
my understanding is you are looking for the frequency of number ...If you want to know frequency number drawn,.you can use Frequency function. enclosed the file.
hello glenn and aan=about frequency is correct, but missing on major=E minor=S and medium=M IN 1st POSITION
major= L MEDIUM = M SMALL = S
EX= 583= M,L ,S 1ª M
No more guessing games, please. Upload a sheet showing EXACTLY what you want. All results. all cells.
you are too focused on a small detail !!!
You forget to explain us the whole picture.
You started a dozen of topics, all almost the same, and i still have no clue.
Take a step backwards.
What is the data you start with ?
What is the goal ?
Hello ok bsalv.
https://www.excelforum.com/attachmen...1&d=1638702885
That is NOT what I asked for. I'm out. Good luck....
Hundreds!!!You started a dozen of topics,
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
go to your grandchild and if not so, go to the child of your neighbours with a age of <10 years.
Explain him/her/x your problem.
If he/she/it understands, send us the (portuguese) text, no xlsx-examples, plain text.
think that everybody is childish.
Last edited by bsalv; 12-05-2021 at 09:23 AM.
HELLO,bsalv but what is doubt? just detect
doubles of patterns after LMS AND POSITIONAL FREQUENCY, WHERE DO WE HAVE THE DOUBT? PLEASE
Hi Jorel,
Attached file is my understanding about what do you want
if correct then you can change each color thru conditioning format.
thank you
huu! hello aan isnaini. very good work, work of art in excel, you know that when you win a prize, you will be rewarded, because then it is easy to reward, many internet users lower the level I post, I don't care,
The objective of this worksheet is to track traffic in the three positions of the pick3, thank you excellent work
hello, aan , just a correction to make, when pick3 are without repeating digits that have 720
there will always be a larger dicta, a smaller and medium one
ex= 489= equals S M L correct
already with the pick3 with pairs of 10 twins there yes
ex= 455 SLL
Dear Jorel,
I don't understand what you mean.
Thank You
hello
4 8 9 0 0 X 0 S L L error
correct= 489=S M 9
489= LSS EROR THE CORECT=489= SML
SMALLEST DIGIT IS 4 THE HIGHEST 9 and the medium is 8
hello,aan!THE MEDIUM DOESN'T MATTER THE POSITION
the medium can be 1st or 2nd or 3rd
Dear Jorel,
as explained on your file, that number 8 defined HIGH?Large.
thank you
spreadsheet has 489= has NO DIGIT 8 = L BUT THE CORRECT IS =M . THE POSITION OF THE THREE LMS STANDARDS DOES NOT MATTER THE POSITION
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks