How to generate all possible five number kombinations of group of numbers without macro

You said you want combinations, not permutations, but your example shows permutations. Combinations would look like this:

1	1	1	1	1
1	1	1	1	2
1	1	1	1	3
1	1	1	1	X
1	1	1	1	5
1	1	1	1	6
1	1	1	1	7
1	1	1	1	8
1	1	1	1	9
1	1	1	1	10

and so on.

Please clarify what you are looking for.

This is a difficult problem to write a general solution for without macros. The way I would do this is to write a macro that generates all the formulas for you. That would be specific to your problem of selecting 5 items from a set of 20. I wouldn't mind doing that if you can clarify your problem.

There's a workbook at https://app.box.com/shared/nqljsd3nlu that will do this. For example, here are the first 16 combinations of 20 choose 5:

Row\Col	B	C	D	E	F	G	H	I	J
2	n	20
3	m	5
4	C(n,m)	15,504
5
6	Comb	n	C1	C2	C3	C4	C5		Helper
7	1	20	4	3	2	1	0		1
8	2	20	5	3	2	1	0		2
9	3	20	5	4	2	1	0		3
10	4	20	5	4	3	1	0		4
11	5	20	5	4	3	2	0		5
12	6	20	5	4	3	2	1		1
13	7	20	6	3	2	1	0		2
14	8	20	6	4	2	1	0		3
15	9	20	6	4	3	1	0		4
16	10	20	6	4	3	2	0		5
17	11	20	6	4	3	2	1		2
18	12	20	6	5	2	1	0		3
19	13	20	6	5	3	1	0		4
20	14	20	6	5	3	2	0		5
21	15	20	6	5	3	2	1		3
22	16	20	6	5	4	1	0		4

The elements are always numbered 0 to N-1 (i.e., 0 to 19 for 20 items).

Here is a version of shg's reference that is tailored to your specific problem.

Note that combinations get big fast--there are over 15,000 combinations of 5 from 20.