It's the ROW function that can't return an array.
If we translate your formula, we get
=OFFSET(A2,INT((ROW(A1)-1)/50),50)
ROW(A1) = 1
=OFFSET(A2,INT((1-1)/50),50)
=OFFSET(A2,INT(0/50),50)
=OFFSET(A2,INT(0),50)
=OFFSET(A2,0,50)
There is no array to return.
Also, the 2nd 50 in there I assume was meant to be the Height argument, is actually in the Columns argument offset by 50 columns.
try
=OFFSET(A2,INT((ROWS(A$1:A1)-1)/50),,50)
Last edited by Jonmo1; 09-20-2017 at 10:16 AM.
think if you need a height you need a width
=OFFSET(A2,INT((ROWS(A$1:A1)-1)/50),,50,1)
The Height and Width arguments are optional.
If omitted, they assume the same height/width as the original range referenced.
Although because of the order of arguments, you would be unable to specify a width without also the height. But you can specify the height without the width.
Hi! Jonmo1
Thank you so much!
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks