Unique Count if Both Values Appear in Column

[ExcelingInLife]

Hello,

I essentially have a table with 3 columns (date, customer, product). I am looking to say on x date used as an expression filter in excel do a distinctcount of the customer column if the customer has both of these products (count of customers owning both products). Any thoughts?

Thank you

 

[CA_Punit]

Do you want the count of distinct customer or names list of customer