From www.journalofaccountancy.com: Excel’s UNIQUE function is a dynamic array tool that allows users to extract unique values from a dataset, effectively identifying and removing duplicates.

The function’s syntax includes parameters for the data range, whether to compare by columns or rows, and whether to return values that appear only once.

Examples demonstrate how to use UNIQUE in conjunction with other functions like SORT and FILTER to create tailored lists based on specific criteria in Excel.