Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

If you are unfamiliar with inputting formulas into Microsoft Excel, the much simpler way to get the number of unique values in an Excel column is through a filter.

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

Learn how to master dense ranking in Excel to fix ranking gaps and improve data analysis with this step-by-step guide. Fix Excel ranking by ...