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