Hi all,
I am trying to remove the rows when there are more than 1 revision ("REV") in the status column.
The table below is the sample data which is updated daily hence there will be some scenarios and the scenario will be
1. if the entry only REV A abc, I want to remove REV A and keep abc
2. if there are 2 entries REV A abc and REV B def, I want to remove row of REV A abc and remove REV B but keep "def" at 2nd row
3. if there are 3 entries REV A abc, REV B def and REV C ghi, I want to remove row of REV A abc and REV B def and remove REV C but keep "ghi" at 3rd row
appreciate any help on this.
thanks
Status |
REV A abc |
REV B def |
REV C ghi |
Solved! Go to Solution.
Thanks @Qiu for the solution and appreciate it.
The solution that you gave worked when there were 3 entries.
In the event, the entry was only one (REV A) or two (REV A and REV B), we need to carry out if logic right?
this is the challenge that I encounter if you can help me to solve.
Thanks.
Two approaches I provided will work for any number of entries. Kindly test
Thanks Qiu
In the event, I have also another data in the same column which I still want to keep such as "xyz pqr stu" and "lmn opq stu", how can I do so?
Status |
REV A abc |
REV B def |
REV C ghi |
xyz pqr stu |
lmn opq stu |
Thanks Qiu
I managed to solve it combining your workflow and Arundhuti's workflow.
Appreciate it.
Thanks @Arundhuti
I managed to solve it combining your workflow and Qiu's workflow.
Appreciate it.