وعليكم السلام
إثراءً للموضوع جرب الكود التالي
Sub Test()
Dim curRow As Long
Dim col As New Collection
Dim itm As Variant
Dim cnt As Long
Dim rng As Range
Dim cel As Range
Const firstRow As Integer = 1 'رقم صف البداية
Const dataCol As Integer = 1 'رقم العمود مصدر البيانات
Const extractCol As Integer = 8 'رقم العمود للنتائج المطلوبة
Application.ScreenUpdating = False
Set rng = Range(Cells(firstRow, dataCol), Cells(Rows.Count, dataCol).End(xlUp))
On Error Resume Next
For Each cel In rng
col.Add Item:=cel.Value, Key:=CStr(cel.Value)
Next cel
On Error GoTo 0
curRow = firstRow
For Each itm In col
cnt = Application.CountIf(rng, itm)
If cnt > 10 Then 'عدد مرات التكرار
Cells(curRow, extractCol).Value = itm
Cells(curRow, extractCol + 1).Value = cnt
curRow = curRow + 1
End If
Next itm
Application.ScreenUpdating = True
End Sub