What is the UNIQUE function in Excel 365 and what does it return?

Question

Microsoft Excel — Hard

What is the UNIQUE function in Excel 365 and what does it return?

Accepted Answer

The UNIQUE function in Excel 365 is a dynamic array function that returns an array of unique values. It removes duplicates from a range and can return values that appear exactly once using the exactly_once argument. This function works on both rows and columns.