Thread: Combination of 8 in sign

Dear All,

In one row I have 8 numbers, I would like to get all the possible sign combinations among the 8 number

for instance:

1 2 3 4 5 6 7 8
1 2 3 4 5 6 7 -8
1 2 3 4 5 6 -7 8

and so on.

usong FACT(8) = 40320, so I guess I would need 40320 combination.

Thank you very much

Fabio

Have a look at ...

http://www.excelforum.com/showthread...75256#poststop

which is a similar problem.