Tool To Use to Only Get Certain Combinations of Data

[latimo1]

I have a dataset:

Name	Status__c	Count
OS-00914089	Cancelled	1
OS-00914089	Completely Shipped	2
OS-00914089	Not Yet Shipped	8
OS-00914097	Cancelled	1
OS-00914097	Completely Shipped	7
OS-00914097	Not Yet Shipped	4
OS-00914097	Partially Shipped	1

I need to find the Names (Order) that only have Completely Shipped and Cancelled as Statuses.

The above records do not meet that criteria but this one does:

OS-00915057	Cancelled
OS-00915057	Completely Shipped

I figured a Formula Tool but am stumped in creating the formula.

Any ideas? Many thanks! John!

[cjaneczko · Accepted solution]

In your final output do you only one to see the one Name or do you want to see the Cancelled and Shipped status as well? The Below will give you just the name. If you wanted the Name with the Status, you can remove the Unique tool.

[latimo1]

Works perfectly! Thank you so much!