Binary Counter

[tom.hogan]

I need to determine the posible outcomes of 4 football games. There are 2^4 (16) possible combinations which can be represented by the binary numbers 0000 to 1111. I need to cycle though each possible outcome to determine final standings. I know how to do this if I can come up with a sub that counts through those bianary numbers.

Any ideas?

Thanks in advance,

Tom

[Lifesigns]

Hi there,

Excel has a function you can use to convert Binary to Decimal called:

BIN2DEC(number)

Perhaps you can use this alongside the binary numbers to perform the calculation?

That said I'm not sure exactly how many calculations there are. Either way you can still use this function even in your code maybe like:

Please Login or Register  to view this content.

lifesigns

[shg]

Another way; in A1 and copy across and down,

=MOD(INT( (ROWS($A$1:A1) - 1) / 2 ^ (COLUMNS($A$1:A1) - 1)), 2)

If you want instead to start in, say, B5, then

=MOD(INT( (ROWS($B$5:B5) - 1) / 2 ^ (COLUMNS($B$5:B5) - 1)), 2)

[tom.hogan]

Life signs thanks that worked.

Tom