Multi Row formula? Formula to decide which ROW to keep
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much for the quick reply.
I adapted this to my Excel Sheets and it works really well!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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