Combinations and Permutations of digits

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