Hi,

I define a dynamic range like this one

=OFFSET(sheet!$J$2;0;0;COUNTA(sheet!$J:$J)-1,1)

however, I have a variable number of columns in that sheet so it could be column "J" but it could as well be column "Q".

How can I replace these fixed columns to a "by column index" reference (for instance column 22) ??