Multi Row formula? Formula to decide which ROW to keep

[pohrt]

I guess this is a beginner question but I cannot get this sorted:

I have a table that always has a pair of rows (BEFORE and AFTER). Depending on the entry in "CHANGES ACCEPTED" I need a new Excel Sheet with the outcome.

• I would like to check if the Excel really has row 2, 4, 6, 8, ... as "BEFORE" and rows 3,5,7,8, .. as "AFTER"
• then (for each pair)
  • IF in ROW "AFTER" the "Changes Accepted" is EMPTY then I want to keep the "BEFORE" ROW
  • IF in ROW "AFTER" the "Changes Accepted" is NOT EMPTY then I want to keep the "AFTER" ROW

This is my Excel

This is what the result should look like:

Thanks already so much for you help.

Petra

[AngelosPachis · Accepted solution]

Hi @pohrt ,

I've mocked a workflow that answers your question. I've split your conditions into Condition 1 and Condition 2 respectively, the former included in the formula tool and the latter in the mutli-row formula tool.

Finally, with the filter tool, you only keep the records that satisfy both those conditions.

Hope that helps, let me know if you have any questions in the workflow.

Regards,

Angelos

[Qiu]

@pohrt 

Appreciate your clear logic.

[Tyro_abc]

Hi @PO

I added one "After" without corresponding "Before" to check if we can find the missing record issue. 

The final result would be like this.

[pohrt]

Thank you so much for the quick reply.

I adapted this to my Excel Sheets and it works really well!

[pohrt]

That is very good too .... I will add this check ....to then be able to go back and see what is wrong.

Thanks very much

Petra