Sub TEST()
Set d = CreateObject("scripting.dictionary")
For Each RN In Sheets("SHEET1").Range("D6:W10")
If Not d.exists(RN.Value) Then
d.Add RN.Value, 1
Else
d(RN.Value) = d(RN.Value) + 1
End If
Next
k = d.Keys
S = d.Items
ReDim ARR(1 To UBound(S) + 1)
For I = 0 To UBound(S)
If S(I) > 0 And S(I) < 6 Then
T = T + 1
ARR(T) = k(I) * 1
End If
Next
ReDim M(1 To T)
For I = 1 To T
M(I) = Format(Application.Small(ARR, I), "000")
Next I
Sheets("SHEET1").Range("D20:D65536").ClearContents
Sheets("SHEET1").Range("D20").Resize(T, 1) = Application.Transpose(M)
End Sub