Forum Discussion

Copper Contributor

Jul 24, 2022

Filter function

I have programmed a formula using the Filter function to bring a short list of items from a large spread sheet and I managed to make it work. But I need to somehow limit the list to a set of rows i...

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Jul 24, 2022

Eduardo_Mata Try it like this:

=INDEX(<your current formula>,SEQUENCE(5),SEQUENCE(,6))

where you replace <your current formula> with what you have now, excluding the =-sign.

If you happen to be an Insider (beta) user, you can use:

=TAKE(<your current formula>,5)

The first SEQUENCE is to keep the top 5 rows, The next SEQUENCE is to keep all 6 columns from the data set.

Eduardo_Mata

Copper Contributor

Jul 25, 2022

Riny_van_Eekelen

I highly appreciate your time and help. I was able to bring a 5 rows of information utlizing the formula that you kindly shared with me.

Thank you so much. Have a great day.