how to dynamic select the rows

[PradeepGupta]

hi,

I am trying to fetch the rows where i get certain data. if my table has 100 rows and 1 column and if i am searching for particular value then i want 6 rows after the value occurs in my fields.

[DavidP · Accepted solution]

Hi @PradeepGupta 

You can use a multi-row formula and filter tool to do this. In below example the row value that I'm looking for is "value10". The multi-row formula then marks the 6 rows after this row by adding a new column. The filter tool then removes all the rows except for the 6 you want to keep.

[vil]

Hi, I'm trying to do a similar thing, but I need to find not 6 rows after specific value, but the amount of rows where a specific value in another field describes the end of a set. Any help would be appreciated.