A possible solution for the challenge – Challenge 72 – Unique characters string from a given string
=CONCAT(UNIQUE(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)))
A possible solution for the challenge – Challenge 72 – Unique characters string from a given string
=CONCAT(UNIQUE(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)))
Instead of ROW-INDIRECT combination, we may now use SEQUENCE function to do the same.
=CONCAT(UNIQUE(MID(A2,SEQUENCE(LEN(A2)),1)))
(or)
=TEXTJOIN("",TRUE,UNIQUE(MID(A2,SEQUENCE(LEN(A2)),1)))