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

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

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

When you press Enter, notice that the result is a spilled array covering cells C1 and C2 because you told Excel to return the top two values.