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 |
