Forum Discussion
EYanik
Apr 08, 2022Copper Contributor
Unique Function Returning Duplicates
I have a short list of about 80 companies that are all the results of Xlookups from a larger list of about 400. I am trying to get a sorted list of unique names. There are some blanks in the origin...
SergeiBaklan
Apr 08, 2022Diamond Contributor
I guess you have both zeroes and blanks, these are different. Like here
Left result is by
=SORT( UNIQUE( FILTER(B2:B9, A2:A9) ) )
If to filter blanks (right column)
=LET(f, SORT( UNIQUE( FILTER(B2:B9, A2:A9) ) ), FILTER(f, f<>"") )
assuming your texts are not more than 255 characters long.