|Ok, so now I made my sheet look like this|
Column A has raw data of client name appearing multiple times
Column B has Product bought by that client
Basically showing every time client bought something regardless of product is it logged.
I went through and created Column D which only has the client name listed once. (which turns out I only have 244 clients)
In column E, I would like to know how many different types of product did a particular company buy.
I do not need to know how many of each product they bought.
I cannot seem to follow what you did in that equation. In the end, I just need to know Company X buys 2 types of product
Company Y buys 1 type
Company Z buys 5 types
etc down the list