Hi Folks,
I have a data as shown below:
Col A | Col B | Flag |
ABC | AS | |
XCV | S | 1 |
SDF | ASA | |
23 | 23 | |
r | 4 | 1 |
Note :
1. Here number of columns can be any, i,e. Col A, Col B , Col C etc.; number of columns are dynamic.
2. Flag column is fixed.
3. Flag will have value as 1 in any 2 rows always.
I need to pick all the rows where FLAG=1 , i.e in above e.g. all the rows where text highlighted as RED.
So, basically, wherever there are two occurrences of Flag=1 in the data, I need to pick all the rows between those rows.
Thanks
Amit
this is your expected output ??
XCV | S | 1 |
SDF | ASA | |
23 | 23 | |
r | 4 | 1 |
you need to Fill down the flag column
use multi row formula and then add filter = 1
IF IsNull([flag]) or ISEMPTY[[flag])
THEN [Row-1:flag]
ELSE [flag]
ENDIF
@amsrivastava
I was trying the multi-row formula but it did not work for me.
So I assign the record ID to each row then find the Row numbers for the flag rows.
Then filter out the rows in between.