Count Unique Values based on another value


Hi all,

Is it possible to count unique values from two separate columns in one formula? In the attached photo I am trying to count the amount of unique "AssociationName" for each unique "CompanyName"? Basically, I want to know how many AssociationName's for each CompanyName.

Does that make sense? Thank you!!!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!