If you are more comfortable with Microsoft Excel functions, you can compute these unique values through a combination of functions as well.

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

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

Functions are built-in shortcuts for common calculations. The Unique function removes duplicates or extracts distinct items from a list.

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.