Forum Discussion

YvesDS's avatar
YvesDS
Copper Contributor
Jan 02, 2023
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...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jan 02, 2023

    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)

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 02, 2023

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's avatar
    YvesDS
    Copper Contributor
    Jan 02, 2023

    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

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jan 02, 2023

      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.

Resources