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 |
Solved! Go to Solution.
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.
could you please provide a workflow solution? thanks very much
@Ryanz3653
We can also try to use the Multi-Row formula tool to flag the target rows.