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 printable pages.
On a first page i have, due to some additional data and text, 40 rows in can spill data in, on a second page i would have something like 60 rows i could spill data in...
I think i will need some sort of a FILTER() function with one time a limited output range of 40 rows, and then on a second page the rest of that data on 60 rows (with a second filter() function, that starts from row 41 to row 60?)
Grtz,
Yves
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)
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,
YvesYvesDS 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.
