combinations calculator

[WELLO]

Permutations and combinations
Hello members, am new to this Forum and i signed on to the forum to help users, but i have encountered a problem myself. I have been trying to combine some numbers and their occurrences but i can't figure it out entirely, it is getting out of control and mind blogging. I need to know how to combine or perm 3 set of numbers with no one order repeating itself but are a total of 14 rows or cells .eg.


1 2 3 2 1 3 1 3 2
2 1 3 1 2 3 ...........
1 3 2 3 2 1 ...........
3 2 1 2 1 3 ...........
1 2 3 3 2 1 ...........
2 3 1 1 3 2 ...........

............ and so on for 14 rows but i need each row to be unique in set of numbers so that no one row set is repeated in any block of 3 columns on that same row. no one block of numbers (that is one set of columns and rows should be the same) should be the same. Please can some one tell me how to go about that in excel. Like the formula or any other means to achieve that.

[dogberry]

http://www.excelforum.com/excel-gene...binations.html

Duplicated post with above