+ Reply to Thread
Results 1 to 6 of 6

All training from 0000000 to 3333333.

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

    All training from 0000000 to 3333333.

    All training from 0000000 to 3333333
    Ex = 0000001
    ****** 0000002
    **...
    * 3333333
    Delete repeated formations
    * Ex = 0000001, 0001000, 0000010 0100000 = Leave only one 0000001
    * And so with the others

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: All training from 0000000 to 3333333.

    Can you give more details about
    "Delete repeated formations
    Ex = 0000001, 0001000, 0000010 0100000 = Leave only one 0000001
    What is a formation ??
    - Battle without fear gives no glory - Just try

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

    Re: All training from 0000000 to 3333333.

    The macro can generate all but will have filter
    Ex =
    0000001 = No need for 0000010 or 0000100. etc
    * Because it will be placed in ascending order only a formation of the group is necessary
    * It's like karnaut map
    Another example
    * 00000002 does not need 0000200 ..... only one

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

    Re: All training from 0000000 to 3333333.

    Hello [COLOR="#FF0000"]P[/COLOR]CI I have a macro but it has only 6 digits have to modify to 7 digit I can post the example ??

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All training from 0000000 to 3333333.

    0000000
    0000001
    0000002
    0000003
    0000011
    0000012
    0000013
    0000022
    0000023
    0000033
    0000111
    0000112
    0000113
    0000122
    0000123
    0000133
    0000222
    0000223
    0000233
    0000333
    0001111
    0001112
    0001113
    0001122
    0001123
    0001133
    0001222
    0001223
    0001233
    0001333
    0002222
    0002223
    0002233
    0002333
    0003333
    0011111
    0011112
    0011113
    0011122
    0011123
    0011133
    0011222
    0011223
    0011233
    0011333
    0012222
    0012223
    0012233
    0012333
    0013333
    0022222
    0022223
    0022233
    0022333
    0023333
    0033333
    0111111
    0111112
    0111113
    0111122
    0111123
    0111133
    0111222
    0111223
    0111233
    0111333
    0112222
    0112223
    0112233
    0112333
    0113333
    0122222
    0122223
    0122233
    0122333
    0123333
    0133333
    0222222
    0222223
    0222233
    0222333
    0223333
    0233333
    0333333
    1111111
    1111112
    1111113
    1111122
    1111123
    1111133
    1111222
    1111223
    1111233
    1111333
    1112222
    1112223
    1112233
    1112333
    1113333
    1122222
    1122223
    1122233
    1122333
    1123333
    1133333
    1222222
    1222223
    1222233
    1222333
    1223333
    1233333
    1333333
    2222222
    2222223
    2222233
    2222333
    2223333
    2233333
    2333333
    3333333
    Entia non sunt multiplicanda sine necessitate

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

    Re: All training from 0000000 to 3333333.

    huu! yes , yes perfect [COLOR="#FF0000"]S[/COLOR]HG, conglatulations 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. [SOLVED] Tracking training Sessions and Leader training with Countif and if statements?
    By lreed in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2017, 06:38 PM
  2. [SOLVED] VBA code for dividing big numbers by 1000,0000000 to make smaller
    By Shahadat65 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2016, 09:44 AM
  3. [SOLVED] Need to Determine Training Room Availability based off a training plan
    By sinspawn56 in forum Excel General
    Replies: 2
    Last Post: 06-08-2015, 03:15 PM
  4. [SOLVED] If cell matches criteria, add 0000000
    By knutfh in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-16-2013, 07:42 AM
  5. Replies: 0
    Last Post: 11-02-2011, 08:47 PM
  6. Macro - schedule people for training based off their schedule and available training
    By downed_pipper1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2009, 04:59 PM
  7. Excel VBA Training by Dunamis Training, LLC
    By Chad Marinelli in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2007, 05:02 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