I have a series of 7 events, matches, each with three possible outcomes,
0, 1 and 3.

I want to list in excel all the possible combinations that could result
from these matches.

So it is just 3 to the power of 7.

I would like them listed as 0,0,0,0,0,0,0 then 0,0,0,0,0,0,1 etc etc.

I have started trying to build a macro to do it but failed miserably.

If anyone can offer any pointers it would be much appreciated.

Thanks


--
Raigmore
------------------------------------------------------------------------
Raigmore's Profile: http://www.excelforum.com/member.php...o&userid=30071
View this thread: http://www.excelforum.com/showthread...hreadid=518960