Originally Posted by
XLent
without more examples it's hard to be sure but, one (O365) option might be:
A2: =TEXTJOIN("",TRUE,TEXT(FREQUENCY(SEARCH(MID($A1,ROW(A$1:INDEX(A:A,LEN($A1))),1),$A1),ROW(A$1:INDEX(A:A,LEN($A1)))),"[<2]"""";#"))
confirmed with CTRL + SHIFT + ENTER
change delimiter to ; if required
edit -- another similar variant but which would return the frequency relative to numbers 0 through 9 (in that order)
=TEXTJOIN("",TRUE,INDEX(TEXT(LEN(A1)-LEN(SUBSTITUTE(A1,ROW($1:$10)-1,"")),"[<2]"""";#"),0))
change delimiter to ; if required
to elaborate on the difference -- were A1 = 34599888 the first would return 23, and the second would return 32 -- the 2nd is different as it looks for each digit 0-9 in sequence, so 8 (3) is found before 9 (2)
Bookmarks