Totti,

I'm not sure how you want your information, or how you plan to use it, but, for example, put 1 2 3 4
..... N (bit numbers) down column A, starting in A2.
Then in row 1, starting in B, put 1, 2, 4, 8, 16, 32, etc.

In cell B2, use the formula

=MOD(INT($A2/B$1),2)

and copy to match your column headers in row 1, and row labels in column A.

Then the resulting table, 1s mean check, 0 means skip...

HTH,
Bernie
MS Excel MVP


"Totti" wrote in message
...
Hi all,
in a excel sheet i want to generate the following sequences for some
array of numbers let us say starting from 0 and going to N-1 bits, the
sequence is from the Hamming Code. For clarity reasons i want to put a
formula in excel that can show me which bit is to be checked as
follows:

Position 1: check 1 bit, skip 1 bit, check 1 bit, skip 1 bit, etc.
(1,3,5,7,9,11,13,15,...)
Position 2: check 2 bits, skip 2 bits, check 2 bits, skip 2 bits, etc.
(2,3,6,7,10,11,14,15,...)
Position 4: check 4 bits, skip 4 bits, etc.
(4,5,6,7,12,13,14,15,20,21,22,23,...)
Position 8: check 8 bits, skip 8 bits, check 8 bits, skip 8 bits, etc.
(8-15,24-31,40-47,...)
Position 16: check 16 bits, skip 16 bits, check 16 bits, skip 16 bits,
etc. (16-31,48-63,80-95,...)
Position 32: check 32 bits, skip 32 bits, etc.
(32-63,96-127,160-191,...)etc.

how can i generate these sequences? using the position
(1,2,4,8,16....) and an array from 0 - N-1, I tried with MOD but i
think i messed it up.
Any help would be appreciated and thanks in advance