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)
Hey Riny,
Would you know the equivalent functionnames in dutch? I can't find any info on the MS excel informations page ...
I use the OFFICE 2021 Pro version.
Thanks in advance, i think this is a very helpfull advice for the use of Filter()
Grtz,
Yves
YvesDS Oh my, I have no clue as I don't use NL Excel. Attached file contains an arrays and two formulas with TAKE and DROP and should translate to Dutch when you open the file.