SOLVED
Data Investigation
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Luk88kk
8 - Asteroid
10-20-2021
12:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
5 REPLIES 5
22 - Nova
10-20-2021
12:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binay2448
11 - Bolide
10-20-2021
12:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binay2448
11 - Bolide
10-20-2021
07:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Luk88kk ,
If our solution worked for you then please mark it as solution.
It will help others if they have similar problem.
10-21-2021
11:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much, both solutions are great and have helped me take my work further. Thank you and have a great weekend.
22 - Nova
10-21-2021
11:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @Luk88kk
Cheers and have a nice day!
