Using Unique Function

[WrkWrk675]

I am using the “UNIQUE” function to create a dynamic array. After I select which cells I want to populate this list, the final value in the last cell for the function spill is “0”. Can someone tell me why this is and if there is a way to remove it?

[#2]

Most likely you have empty cells in your range.

[#3 · Accepted solution]

@WrkWrk675 

Depends on what you'd like to do with blanks. Variants are

=LET( u, UNIQUE(range), IF( u="", "", u ) )

or

=LET( u, UNIQUE(range),  FILTER( u, u <> "" ) )