The UNIQUE function extracts a list of unique values from a range or array. The result is a dynamic array that spills onto the worksheet, automatically updating when source data changes.

The UNIQUE function extracts a list of unique values from a range or array. The result is a dynamic array that spills onto the worksheet, automatically updating when source data changes.