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.

Excel formulas like UNIQUE, COUNTIF, and CONCATENATE offer flexibility for identifying and handling duplicates in complex datasets.

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.

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.

How easy was that? Without that unique list, the solution is much more complex. Excel’s COUNTA () function counts the number of cells in the referenced range that aren’t empty.