The visibility rule: Excel only says what it can see. If you use filters to hide specific rows, Excel skips over them ...
To make the most of the UNIQUE function, you should make sure your array is in an Excel table. By using a table name rather ...