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
PeterBartholomew1
djclements
SergeiBaklan
This is exactly what makes you guys magicians. You provided 3 solutions, when I was struggling to work out one. Heartfelt thanks for being here!
I had to close the question by marking one of above as best response. But that does not, in any way, diminish my appreciation for the effort you guys put it! Thanks a Lot! Sincerely!
KanwalNo1 , you are welcome, thank you for the feedback