It's easier than it could appair...
Thank you

"Joel" wrote:

Use Row 2 instead of Row 1 to compute your offsets

from
OFFSET($A$1,1,INT((COLUMN(B1)-2)/4)*4+1)

to
OFFSET($A$2,0,INT((COLUMN(B2)-2)/4)*4+1)


"Lucio Menci" wrote:

Hi,

I have cells B1:E1 merged, and F1:K1 merged and so on.
In the rest of my sheet I have formulas that have to refer to the content of
first row.
If the formula refers to B1, it runs, but if it refers to C1 or D1, it
doesn't run.

In the past, I had all merged range with the same number of cells, then,
instead of C1, I putted
OFFSET($A$1,1,INT((COLUMN(B1)-2)/4)*4+1)
but it isn't always true.