Feb 10 2022 02:56 PM
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?
Feb 11 2022 12:51 AM
SolutionDepends 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 <> "" ) )
Feb 11 2022 12:51 AM
SolutionDepends 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 <> "" ) )