excel data


first column,then row

=OFFSET($A$1,COLUMN(A1)-1+(ROW(A1)-1)*4,)

first row then column

=OFFSET($A$1,ROW(A1)-1+COLUMN(A1)*4-4,)

Leave a Reply

Your email address will not be published. Required fields are marked *