Have UNIQUE() optionally ignore blanks
The new UNIQUE(), SORT() and SORTBY() functions are incredibly useful and they save a lot of time. It would be helpful though to allow UNIQUE() to optionally ignore blanks. I use UNIQUE() to build named arrays dynamically which I can use as a validation list for data validation. At the moment I have to create the list (e.g. SORT(UNIQUE(<some column in a table>)) and then created a Name using OFFSET() to ignore the blank at the start of the sorted list.
I've realised that the new FILTER() function can be used for this:
UNIQUE(FILTER(ARRAY, ARRAY <> ""))
Which works very well!