Hello,
i am after either a program or a formula on excel to create sets of combinations of random digits example
i want to beable to select 1 or 2 or 3 etc.. groups of digits and in each group i want to be able to select 1 or 2 or 3 etc.. sets of digits to input in each group
example 1
2 groups each containing 3 sets of digits
A
B
C
D
E
F
example 2
3 groups containing 3 sets of digits
1
2
3
4
5
6
7
8
9
from this i want to beable to produce every combations possible and to be displayed in sets
example 3.
3 groups with 4 sets and to display groups of 4 using 2 sets
1 1 1 1 1 1 1 1 1
2 2 2 2 2 2 2 2 2
3 3 3 3 3 3 3 3 3
4 4 4 4 4 4 4 4 4
5 5 5 5 5 5 5
6 6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8
9 9 9 9 9 9 9
10 10 10 10 10 10 10
11 11 11 11 11 11 11
12 12 12 12 12 12 12
and so on...
this took me while to type up :O) and then i want to have options such as remove all duplicates (example 3 doesnt have any would of just took me longer to type)
other option is to remove any numbers that are in sequence starting from 2 and above or 3 digits and above or 4 digits and above etc...
thankyou for taking the time to read this i preffer someone who has done this before and can show screen shots of the interface as well