Allow UNIQUE() to operate on a rectangular range, returning all unique values
The new Dynamic Array function UNIQUE is awesome. It can return all of the unique items in a column or in a row. But it would be nice if the second argument could accept a 3 to indicate cell-by-cell.
For example, see the screenshot below.
I arrgee whit you ,
We need the flexibility that is described herein.
John Borg commented
Never knew about this until I saw Bill's video.