Might sound crazy But here goes

[jimblimm]

In cell A1 if have a number
9921

i would like to know which formula i should use to extract the non duplicate digits in the number. the number would display in 2 in b1 and 1 in b2

sometime the number might have 3 duplicate digits

example: 9991

but if the number has 2 sets of duplicate digits
example

9911 i would need to extract the duplicates

example the result would be display 9 in b1 cell and 1 b2

 

[bstory84]

i know your question was for it to display in seperate cells. but i could not think of a way to do that.

If this is not what you are looking for i understand, but here is a UDF that will return to you all unique Characters in a string (cell).

Option Explicit
Function Unique_Char(usrCell As String) As String
Dim strCount As Integer
Dim allUnique As New Collection
Dim i As Integer
Dim single_char As String
Dim result As String
Dim item As Variant
    strCount = Len(usrCell)
    On Error Resume Next
    
    For i = 1 To strCount
        single_char = Mid(usrCell, i, 1)
    
        allUnique.Add item:=single_char, Key:=single_char
    Next i
    For Each item In allUnique
        result = result & item
    Next item
Unique_Char = result
End Function