Data Investigation

[Luk88kk]

Good morning,
I try to use a multi row formula to remove invalid values from my database.
For example, I need to remove values ​​from rows that:
1. have decisions but no dates;
2. there are dates but no decisions.

The result should be like this:

I am very much asking for your support.

[atcodedog05 · Accepted solution]

Hi @Luk88kk 

You use formula tool like below.

Workflow:

Hope this helps : )

[binay2448 · Accepted solution]

Find attached solution for the same..

[binay2448]

Hi @Luk88kk ,

If our solution worked for you then please mark it as solution.

It will help others if they have similar problem.

[Luk88kk]

Thank you very much, both solutions are great and have helped me take my work further. Thank you and have a great weekend.

[atcodedog05]

Happy to help : ) @Luk88kk 

Cheers and have a nice day!