Removing rows with specific condition

[sadikinisaac]

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

[Qiu]

@sadikinisaac 

Only single row date is required for output, right?

[sadikinisaac]

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.

[Tyro_abc · Accepted solution]

Hi

Can you try attached workflow? It should work with any number of entries as long as you have a sequence in your revision number.

Best Regards

Arundhuti

[Qiu]

@sadikinisaac 

Two approaches I provided will work for any number of entries. Kindly test

[sadikinisaac]

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

[Qiu · Accepted solution]

@sadikinisaac 

Like this.

[sadikinisaac]

Thanks Qiu

I managed to solve it combining your workflow and Arundhuti's workflow.

Appreciate it.

[sadikinisaac]

Thanks @Arundhuti

I managed to solve it combining your workflow and Qiu's workflow.

Appreciate it.