Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make quick work of this challenge.

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.