When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions. The TechRepublic article How to create a sorted unique list in an Excel ...
Like Microsoft Excel, Google Sheets includes a simple COUNT function that tells you the number of items in the selected range. But what if you want to know the number of items based on some condition ...