If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't fret over a complex expression when you can easily remove those duplicates.

Combining UNIQUE with COUNTA allows you to count the number of unique entries in a dataset. Dynamic array formulas in Excel 365 enhance the flexibility and efficiency of the UNIQUE function.

The easiest way to spot a unique value is to format it, and Microsoft Excel offers two ways to do so.

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

How to Highlight Every Other ID in Excel. When reading across a wide list of data, such as an account ledger or product description list, it is easy to confuse the rows.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.