how to filter out a chunk of dataset?

[Ryanz3653]

Hi community, i have a sample dataset as follows, i only need the part to form the table that is between and including 'start' to 'end', 4 lines in total. In the real case i may have thousands of rows and i know how to find 'start' row and 'end' row already.

How to i do that?

Thank you for your help

ID	PART	LOGIC
12	ADD
1256	FDD	START
1052	AFF
ADF1	AGF
23D	GHR	END
34	DFG

[apathetichell]

recordid

filter - start value and end value in logic.

crosstab start/end record ids into one row of start value/end value.

append this to your original list

filter if the recordid is between these two values.

[Ryanz3653]

could you please provide a workflow solution? thanks very much

[Qiu · Accepted solution]

@Ryanz3653 
We can also try to use the Multi-Row formula tool to flag the target rows.