math - Generate all possible combinations of a set of numbers in excel -

how can generate possible combinations, in excel, using 3, 6 , 9 in 5 digit number? naturally digits can repeat.

i trying learn more excel , cannot figure out - how generate possible combinations , see them instead of having number of possibilities.

i've looked through many forums, there's nothing can use...

http://planetcalc.com/3756/?license=1 - link online generator, there must mistake in code since doesn't show 5 digit numbers.

just loop on selections:

sub maja()   dim k long   k = 1   vals = array("3", "6", "9")   each in vals     each b in vals       each c in vals         each d in vals           each e in vals             cells(k, 1) = & b & c & d & e             k = k + 1           next e         next d       next c     next b   next   msgbox k end sub 

a snap of top of list:

note:

technically, call these permutations rather combinations because values 33363 , 33336 both appear in list represent different numerical values.