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.

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

In Excel 365, the “Unique” function filters out repeated items, showing only those appearing exactly once, while the “Distinct” function lists all distinct items, regardless of frequency.

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 work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.