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

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.

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array 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.

Microsoft Excel is incredibly versatile, but there are a lot of functions you might not even know about. These are some of the best ones.