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

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

Both function combinations will skip over any blank row and will not count towards the running total of unique values, as there is no value to be counted.

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.