SOLVED

Using Unique Function

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3152102%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EUsing%20Unique%20Function%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3152102%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20am%20using%20the%20%E2%80%9CUNIQUE%E2%80%9D%20function%20to%20create%20a%20dynamic%20array.%20After%20I%20select%20which%20cells%20I%20want%20to%20populate%20this%20list%2C%20the%20final%20value%20in%20the%20last%20cell%20for%20the%20function%20spill%20is%20%E2%80%9C0%E2%80%9D.%20Can%20someone%20tell%20me%20why%20this%20is%20and%20if%20there%20is%20a%20way%20to%20remove%20it%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3152102%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

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 Replies
Most likely you have empty cells in your range.
best response confirmed by WrkWrk675 (Occasional Visitor)
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 <> "" ) )