Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

The UNIQUE function in Excel 365 is designed to extract distinct values from a given range of data.

Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks. The hardest part is finding it!

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.