And if you want it in VBA, then the logic would be

Sub test()
Dim Position As Variant
Dim iBit As Integer
Dim i As Integer
Dim Check As String

Position = Array(1, 2, 4, 8, 16, 32)
Check = ""

For i = LBound(Position) To UBound(Position)
For iBit = 1 To 63
If iBit \ Position(i) Mod 2 = 1 Then
Check = Check & "1"
Else
Check = Check & "0"
End If
Next iBit
Check = Check & vbCrLf
Next i

MsgBox Check

End Sub
--
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