Excel Genius Required!
Not sure that I fully got your point, but how about this:
Row 1 contains the "tens" and column A contains the "ones" of a 2-digit
decimal number that is just converted to binary thus showing all
possible combinations of 0s and 1s.
0 1 2 3 4 5
0 00000000 00001010 00010100 00011110 00101000 00110010
1 00000001 00001011 00010101 00011111 00101001 00110011
2 00000010 00001100 00010110 00100000 00101010 00110100
3 00000011 00001101 00010111 00100001 00101011 00110101
4 00000100 00001110 00011000 00100010 00101100 00110110
5 00000101 00001111 00011001 00100011 00101101 00110111
6 00000110 00010000 00011010 00100100 00101110 00111000
7 00000111 00010001 00011011 00100101 00101111 00111001
8 00001000 00010010 00011100 00100110 00110000 00111010
9 00001001 00010011 00011101 00100111 00110001 00111011
The formula in B2 is: =DEC2BIN(VALUE(B$1&$A2);8)
Copy right and down to fill the matrix.
How did you manage to get the Excel example into your post? Would slve
my formatting problems above.
Hans
|