Forum Discussion
Solved
Finding Unique Values
PeterBartholomew1 djclements SergeiBaklan Hi Magicians! Column B of Sheet 1 in the attached file contains the data exported from an accounting software. The Ledger Account Names are separated by...
I'm not a magician, but how about
=LET(v, UNIQUE(TEXTSPLIT(TEXTJOIN(CHAR(10), TRUE, VSTACK(B10:B13)), , CHAR(10))), FILTER(v, ISERROR(SEARCH("Bill No", v))))
As variant
=DROP( REDUCE("", Particulars, LAMBDA(a,v, UNIQUE( VSTACK(a, DROP( TEXTSPLIT(v,,CHAR(10)), -1) ) ) ) ), 1)but with poorer performance compare to djclements variant