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

Multi Row formula? Formula to decide which ROW to keep

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

Common Use Cases

Accepted answers

AngelosPachis

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.