Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. I. KatzUp Up and Array!https://doi.org/10.1007/978-1-4842-8966-2_5

5. UNIQUE: A Singular Function

Abbott Ira Katz¹  

(1)

Edgware, UK

 

What’s Unique About It?

The UNIQUE dynamic array function hurdles an old spreadsheet stumbling block – how to extract a unique set of entries from a field – without breaking a sweat. For example, we might need to compile a list of the salespersons archived in the Salesperson field of this dataset (file: UNIQUE), as portrayed in Figure 5-1.

A table has 5 columns and 15 rows. The column headers are country, salesperson, order date, ...