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.
Kanwaljit Dhunna commented
I understand Filter Can be used for this, but even then why not add this highly useful functionality to the UNIQUE Function itself. This option can be used directly to ignore any blank rows appearing at the start, middle, last or any where in the array.
I've realised that the new FILTER() function can be used for this:
UNIQUE(FILTER(ARRAY, ARRAY <> ""))
Which works very well!