decrease 9999 8888 1111 from the last draw of pick 4 = 0784. then break down into 4 pick3 the 9999 8888....1111 are fixed what changes every week are in the blue sector the macro has decrease
https://www.excelforum.com/attachmen...1&d=1633777450
decrease 9999 8888 1111 from the last draw of pick 4 = 0784. then break down into 4 pick3 the 9999 8888....1111 are fixed what changes every week are in the blue sector the macro has decrease
https://www.excelforum.com/attachmen...1&d=1633777450
hello please!
Can you explain where the numbers for the 3rd, 4th and 5th green results came from for the first row of data (the 9999 row)? The 3rd green field asks for 1, 2 and 4 but you wrote what looks like the numbers for 1, 3 and 4. The 4th green field asks for 1, 3 and 4 and you wrote what looks like 1 and 3 and then invented a 4 for the last digit... where did the 4 come from. As for the 5th green field, it asked for 2, 3 and 4 and you wrote those numbers from the value in the blue field not the numbers from the 1st green field. Given those results, I'm confused as to the rule for filling in those last three green fields. Can you clarify what is going on please?
Also, your numbers in the blue field are supposed to be a Pick 4 number, correct? What should happen if the first digit is not 0? Negative number will result from some of the subtractions... how should those results be handled (you need to show us an example)?
Last edited by Rick Rothstein; 10-11-2021 at 11:49 PM.
ok rick let's go step by step
in the blue sector is the last draw of pick4
was 0784, in the part of 9999 .8888,7777.... 1111
will always be fixed, the macro will decrease 9999-0784
deu= 9215, then it is broken down into 4 pick3
ok sorry where there is 4 the value is 5,
goal = is to find with the decrease 4 pick3
every week in the blue sector changing the draw is only fixed at 9999...1111
1ª 2ª 3ª 4ª 1ª 2ª 3ª 1ª 2ª 4ª 1ª 3ª 4ª 2ª 3ª 4ª corret
9 2 1 5 9 2 1 9 1 5 9 1 5 2 1 5
8 1 0 4 8 1 0 ?
desmenbrer=
123
124
134
234
hello rick corret , sorry
https://www.excelforum.com/attachmen...1&d=1634024424
rick, for values where we have 4444,3333,2222,1111, the decrease sign will appear, do not take into account, ignore the sign
helo rick, what's the question?
Just double checking... your profile says you are using Excel 2014... is your computer a Mac?
no! my excel(office) is 2016, i am using windows 7 professional
objective= is to decrease the last pick4 at the fixed reference of 9999 .8888.... 1111
then convert to 3 pick3
If you look at your profile, it says you are using "excel 2014"... you should change it to reflect your actual version.
rick 2014 was the year I registered in the excel forum, my current excel is 2016
Look at the left side of any message you posted... at the top is your name... look down to the line starting with "MS Off Ver:"... yours says "excel 2014"... you need to change that to either "Excel 2016" or "XL2016". To do that, scroll all the way to the top of this forum's window and click on the "My Profile" link... when your profile page comes up, click the "About Me" tab and then look down till you find the line about the Office version... click the icon that looks like a yellow pencil... that will allow you to correct your Excel version information.
As for your original question, give this macro a try...
Please Login or Register to view this content.
Last edited by Rick Rothstein; 10-14-2021 at 03:00 PM.
ok RICK, perfect work of art work!
ok, congratulations, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks