excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 534
- Office Version
- 365
- Platform
- Windows
hi,
i googled quite a lot, found a lot but not what i'm looking for,
i need a simple macro to generate an x numbers out of a range,
so i can edit it each time per my need,
with no repeation
for example
range will be a2:h2 (or more or less)
numbers of combinations 5 (or more or less)
if possible with hyphens seperate between i.e 1-2-3-4-5
all results in one column
can you please help?
i googled quite a lot, found a lot but not what i'm looking for,
i need a simple macro to generate an x numbers out of a range,
so i can edit it each time per my need,
with no repeation
for example
range will be a2:h2 (or more or less)
numbers of combinations 5 (or more or less)
if possible with hyphens seperate between i.e 1-2-3-4-5
all results in one column
can you please help?
New Microsoft Excel Worksheet.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | of 6 | of 5 | ||||||||||
2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 1-2-3-4-5-6 | 1-2-3-4-5 | ||
3 | 1-2-3-4-5-7 | 1-2-3-4-6 | ||||||||||
4 | 1-2-3-4-5-8 | 1-2-3-4-7 | ||||||||||
5 | 1-2-3-4-6-7 | 1-2-3-4-8 | ||||||||||
6 | 1-2-3-4-6-8 | 1-2-3-5-6 | ||||||||||
7 | 1-2-3-4-7-8 | 1-2-3-5-7 | ||||||||||
8 | 1-2-3-5-6-7 | 1-2-3-5-8 | ||||||||||
9 | 1-2-3-5-6-8 | 1-2-3-6-7 | ||||||||||
10 | 1-2-3-5-7-8 | 1-2-3-6-8 | ||||||||||
11 | 1-2-3-6-7-8 | 1-2-3-7-8 | ||||||||||
12 | 1-2-4-5-6-7 | 1-2-4-5-6 | ||||||||||
13 | 1-2-4-5-6-8 | 1-2-4-5-7 | ||||||||||
14 | 1-2-4-5-7-8 | 1-2-4-5-8 | ||||||||||
15 | 1-2-4-6-7-8 | 1-2-4-6-7 | ||||||||||
16 | 1-2-5-6-7-8 | 1-2-4-6-8 | ||||||||||
17 | 1-3-4-5-6-7 | 1-2-4-7-8 | ||||||||||
18 | 1-3-4-5-6-8 | 1-2-5-6-7 | ||||||||||
19 | 1-3-4-5-7-8 | 1-2-5-6-8 | ||||||||||
20 | 1-3-4-6-7-8 | 1-2-5-7-8 | ||||||||||
21 | 1-3-5-6-7-8 | 1-2-6-7-8 | ||||||||||
22 | 1-4-5-6-7-8 | 1-3-4-5-6 | ||||||||||
23 | 2-3-4-5-6-7 | 1-3-4-5-7 | ||||||||||
24 | 2-3-4-5-6-8 | 1-3-4-5-8 | ||||||||||
25 | 2-3-4-5-7-8 | 1-3-4-6-7 | ||||||||||
26 | 2-3-4-6-7-8 | 1-3-4-6-8 | ||||||||||
27 | 2-3-5-6-7-8 | 1-3-4-7-8 | ||||||||||
28 | 2-4-5-6-7-8 | 1-3-5-6-7 | ||||||||||
29 | 3-4-5-6-7-8 | 1-3-5-6-8 | ||||||||||
30 | 1-3-5-7-8 | |||||||||||
31 | 1-3-6-7-8 | |||||||||||
32 | 1-4-5-6-7 | |||||||||||
33 | 1-4-5-6-8 | |||||||||||
34 | 1-4-5-7-8 | |||||||||||
35 | 1-4-6-7-8 | |||||||||||
36 | 1-5-6-7-8 | |||||||||||
37 | 2-3-4-5-6 | |||||||||||
38 | 2-3-4-5-7 | |||||||||||
39 | 2-3-4-5-8 | |||||||||||
40 | 2-3-4-6-7 | |||||||||||
41 | 2-3-4-6-8 | |||||||||||
42 | 2-3-4-7-8 | |||||||||||
43 | 2-3-5-6-7 | |||||||||||
44 | 2-3-5-6-8 | |||||||||||
45 | 2-3-5-7-8 | |||||||||||
46 | 2-3-6-7-8 | |||||||||||
47 | 2-4-5-6-7 | |||||||||||
48 | 2-4-5-6-8 | |||||||||||
49 | 2-4-5-7-8 | |||||||||||
50 | 2-4-6-7-8 | |||||||||||
51 | 2-5-6-7-8 | |||||||||||
52 | 3-4-5-6-7 | |||||||||||
53 | 3-4-5-6-8 | |||||||||||
54 | 3-4-5-7-8 | |||||||||||
55 | 3-4-6-7-8 | |||||||||||
56 | 3-5-6-7-8 | |||||||||||
57 | 4-5-6-7-8 | |||||||||||
test |