The following CSE function gives a value error
=TRANSPOSE(OFFSET(Data!$A$1,(ROW()-1)*9,0,9,1))
but if I move the section (ROW()-1)*9 out to its own cell and then reference that cell in the CSE function
=TRANSPOSE(OFFSET(Data!$A$1,K6,0,L2,1))
it works fine.
Is there a way to include the row argument in the CSE function?
Bookmarks