[vba]Код
Sub CountUniqueValues()
Dim oDic As Object, rng As Range
Set oDic = CreateObject("Scripting.Dictionary")
For Each rng In Sheets("График").Range("A1").CurrentRegion
If rng.Value <> "" Then
If oDic.Exists(rng.Value) Then
oDic(rng.Value) = oDic(rng.Value) + 1
Else
oDic(rng.Value) = 1
End If
End If
Next rng
With Sheets("Статистика")
.UsedRange.ClearContents
.Range("A1").Resize(oDic.Count) = Application.Transpose(oDic.Keys)
.Range("B1").Resize(oDic.Count) = Application.Transpose(oDic.Items)
End With
End Sub
[/vba]