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 ...
To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10. In a previous TechRepublic article, How to highlight the top n values in a ...