Need match of two different values

[richmcgill]

I have a list of customers each with a unique ID number
Each customer can show up multiple times on a very large report. The customer ID stays consistent throughout and does not change.
Each Customer can have a status of Ordered or Ordering or None
Using the customer number I need to know which customer number has both "Ordered" & "Ordering" in its status field. If both are not present I do not need a result. I do not need to know the customers with a None status.

The Result should be a Yes or No. Yes both are present or No both are not present.

 

[richmcgill]

This works perfectly. Thank you very very much for your help.

 

[Eric W]

Glad we could help.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.