Plotting permutations on an excel spreadsheet

[spadian]

I have a report that I am contrstucting where I need to represent all posible computations. The Report will look something like this

Scenario
A B C D E
1 x o o o
2 x x o o
3 x x x o
4 x x x x


The are over 1000 permutations and doing it manually will take a very long time and its verfy difficult to identify a mistake. If any knows a formula or a quicker method that would be much appreciated.

Many Thanks,
Matt

[MickG]

Hi, Try this:-
Place your data in individual cells in row (1).
Run the code, select this row in Input Box. Max Columns (7).
Click OK results in Rows below.

Please Login or Register  to view this content.

Regards Mick

[spadian]

Thanks Mick. That was quite complex. Much appreciated