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))))
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))))