is this letters or numbers?
there is a handy tool here
http://www.ne.jp/asahi/math.edu/ami/myprog/jk_eng.htm
although it specifies letters you can use 0-9 as well
there is also this code from myna larson
put C in A1 (c for combinations p for permutations).
4 in A2 ((the number of combinations you want)
1-11 in A3:A13 (or 11 diferent text items if you want)
run the macro ListPermutations a new sheet will be added with all the combinations.
note apparently in excel 2007 you need to replace
with this
this is the full code
Bookmarks