Possible combinations

**bobbak** · 02-22-2008, 04:32 PM

I am trying to come up with a way to show all combinations for 4 numbers across 5 rows.
POssible numbers are -1, 0,1,2
The 5 rows will have one of these numbers Ex.
-1, -1, -1, -1,-1
-1, -1, 0, 1, 2
etc.
Is there a easier way to list the entire set of combinations?
Thanks in advance for any help offered!

**shg** · 02-22-2008, 04:57 PM

In A1:E1, enter -1

In A2 and copy across to D2: =IF( AND(B1 <> -1, B2 = -1), MOD(A1 + 2, 4) -1, A1)

In E2: =MOD(E1 + 2, 4) -1

Copy A2:E2 down to A1024:E1024.