+ Reply to Thread
Results 1 to 14 of 14

decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

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

    decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    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
    Attached Files Attached Files

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

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    hello please!

  3. #3
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    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.

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

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    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

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

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    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

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

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.


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

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    rick, for values where we have 4444,3333,2222,1111, the decrease sign will appear, do not take into account, ignore the sign

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

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    helo rick, what's the question?

  9. #9
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    Just double checking... your profile says you are using Excel 2014... is your computer a Mac?

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

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    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

  11. #11
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    If you look at your profile, it says you are using "excel 2014"... you should change it to reflect your actual version.

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

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    rick 2014 was the year I registered in the excel forum, my current excel is 2016

  13. #13
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    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.

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

    Re: decrease 9999 8888 1111 from the last draw of pick 4 = 0784.

    ok RICK, perfect work of art work!
    ok, congratulations, thank you

+ 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. How can i do 1111......2222......33333......44444....
    By Ipinho100 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-16-2023, 12:03 AM
  2. [SOLVED] convert in ascending order each pick 3 from the draw list .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2021, 09:50 AM
  3. [SOLVED] please, chosen 4 digits * decrease by 9999 and add by * 9999.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2019, 12:18 PM
  4. Replies: 8
    Last Post: 05-15-2017, 05:54 AM
  5. Formatting ID numbers to include dashes. Ex. from this 111111111 to this 111-11-1111
    By snowthedirtbub in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-18-2013, 03:00 AM
  6. Replies: 3
    Last Post: 01-16-2012, 09:07 PM
  7. I need to make 111-11-1111 into 111111111
    By Crawdaddy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-22-2005, 05:05 PM

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