Unique list with AND and OR logic as multiple criteria

Hi,

I'm trying to develop a unique list with multiple criteria. In my attachment, Column A has the data to look at, Column F has the result. I was trying to create a formula similar to the ones found here: https://www.ablebits.com/office-addi...tiple-criteria.

The main criterias are to list unique values based on:
*If the data contains "FDBK" or "CMD" somewhere in the name
*Remove blanks from the unique list
*Display only unique values in addition to the first two criteria

Please let me know if you can help out with this. I feel I am somewhat close, I'm guessing I need to use a combination of COUNTIFS and COUNTIF somehow.... Maybe I need the value to return a value of one, though?

Thank you, Tony!! This works well