how many formations are possible using ascending strings?

Reply #4

dr san — Tue, 12 Feb 2019 22:22:09 GMT

ok, Mr-B 216, perfect, thank you

Reply #3

Mr-B 216 — Tue, 12 Feb 2019 21:18:56 GMT

dr san, I suggest you (and many others here) learn how to use Excel to your advantage. Press F1 in Excel for help, and in this case, find help on using CONCATENATE. Google is also your friend, with hundreds of online tutorials.

You can easily do many things in Excel on your own. You will be doing yourself a huge favor by doing the work yourself. Many tasks do not require the use of macros, and while programming knowledge is helpful, it most certainly is not required.

Excel is a tool, and l... [ More ]

Reply #2

dr san — Tue, 12 Feb 2019 20:26:27 GMT

hello, but the formations must have 7 numbers

then example = choose a string of 14 digits, the macro has to generate all the possible combinations

knowing that the 4,5,6,7,8,9,0 are last digits because it goes from 01 to 31

28 last digit = 8

Reply #1

Mr-B 216 — Tue, 12 Feb 2019 16:30:31 GMT

Results for string = 00011112246678 = 14 digits:

0

0

0

1

1

1

1

2

2

4

6

6

7

8

^ Total one digit numbers is ^ 14

00

00

01

01

01

01

02

02

04

06

06

07

08

00

01

01

01

01

02

02

04

06

06

07

08

01

01

01

01

02

02

04

06

06

07

08

11

11

11

12

12

14

16

16

17

18

11

11

12

12

14

16

16

17

18

11

12

how many formations are possible using ascending strings?

dr san — Tue, 12 Feb 2019 13:20:19 GMT

how many formations are possible using ascending strings?

example is for a 31/7 lottery

string = 00011112246678 = 14 digits

can generate this = 01 06 08 14 17 21 26

ok, but could generate more, the question is

how many more?

or a string given how many formations would it have