Forum Discussion
Remove all rows with same ID based on another row's input
Hi Anonymous ,
Here's my solution.
1.Group by ID.
2.Add a custom column to check if Status = "Complete".
3.Remove the rows with ture.
4.Expand the Count column and remove the unneeded column.
You can check more details from my attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Here's my solution.
1.Group by ID.
2.Add a custom column to check if Status = "Complete".
3.Remove the rows with ture.
4.Expand the Count column and remove the unneeded column.
You can check more details from my attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What if you have more thank just 1 criteria of Status = Completed? How would you add Status = Completed and Rank = 0 as an example?