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.

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

This article shows how to count nonblank cells in Excel by using differnt functions and built-in feature in Microsoft Excel.

Learn how to sum and count Excel cells by color with 3 easy methods. Save time, reduce errors, and boost your data analysis skills today ...

If you've ever had a data dump into a spreadsheet result in a mess of duplicate values, follow this step-by-step to learn how to remove them.

To count colored cells in Microsoft Excel, you may use the Find and Select tool or the Excel Filter and SUBTOTAL() function.