Count Distinct Values Per Attribute

[scosner]

Hi,

I'm trying to write a formula to count the number of unique product types per client (example attached). e.g. ABC Capital LLC has two distinct product types - A and B, whereas XYZ Capital has only one product type - A.

Any help is greatly appreciated. I cannot use pivot tables to do this because I need to build on this formula to extract more metrics

Thanks

[sktneer]

Hi scosner,
Welcome to the Forum.

Try this Array formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter. (Hope you are familiar with Array Formulas)

In C2

Please Login or Register  to view this content.

and then copy down.

[scosner]

I am familiar with arrays and this works perfectly. Thank you so much