Sub Macro1()
Dim arr, brr, w, d, i&, j%, x%
Set d = CreateObject("scripting.dictionary")
arr = Range("j5").CurrentRegion
w = Array("●", "▲", "■")
ReDim brr(1 To UBound(arr), 1 To 3)
For i = 1 To UBound(arr)
x = arr(i, 1) Mod 3
For j = 0 To 2
If x = j Then
brr(i, j + 1) = w(j)
d(j) = 0
Else
d(j) = d(j) + 1
brr(i, j + 1) = d(j)
End If
Next
Next
Range("ax5").Resize(UBound(brr), 3) = brr
End Sub
Sub Macro1()
Dim arr, brr, w, d, i&, j%, x%
Set d = CreateObject("scripting.dictionary")
arr = Range("j5").CurrentRegion
w = Array("●", "▲", "■")
ReDim brr(1 To UBound(arr), 1 To 3)
For i = 1 To UBound(arr)
x = arr(i, 1) Mod 3
For j = 0 To 2
If x = j Then
brr(i, j + 1) = w(j)
d(j) = 0
Else
d(j) = d(j) + 1
brr(i, j + 1) = d(j)
End If
Next
Next
Range("ax5").Resize(UBound(brr), 3) = brr
End Sub