Sub Occur()
Set mondico = CreateObject("Scripting.Dictionary")
For Each c In Range("a2", [a65000].End(xlUp))
mondico(c.Value) = mondico(c.Value) + 1
Next c
[c2].Resize(mondico.Count, 1) = Application.Transpose(mondico.keys)
[d2].Resize(mondico.Count, 1) = Application.Transpose(mondico.items)
End Sub