Forum Discussion
Solved
distributing rows with filter() functions over multiple print pages
Hi all, I use the filter() function to succesfully fill a sort of invoice-like page with data. But depending on the amount of data, i would sometimes need the data to be spread over two or more pri...
YvesDS Look into functions TAKE and DROP. The first lets you take the first n rows of an array. And DROP lets you remove the first n rows of an array.
It could look like this:
=TAKE(FILTER(......),40)
and
=DROP(FILTER(......),40)
YvesDS Look into functions TAKE and DROP. The first lets you take the first n rows of an array. And DROP lets you remove the first n rows of an array.
It could look like this:
=TAKE(FILTER(......),40)
and
=DROP(FILTER(......),40)