Option Explicit
Sub ThKeDiem()
Dim eRw As Long, Zf As Long
Dim Rng As Range, sRng As Range, Clls As Range, tRng As Range
Dim MyAdd As String
Set Rng = Range([d10], [d10].End(xlDown))
eRw = [d10].End(xlDown).Row
Range([K3], Cells(eRw, "L")).ClearContents
With [i1].Interior
If .ColorIndex < 34 Or .ColorIndex > 41 Then
.ColorIndex = 34
Else
.ColorIndex = .ColorIndex + 1
End If
End With
For Each Clls In Range([j3], [j4].End(xlDown))
Set sRng = Rng.Find(Clls.Value, , xlValues, xlWhole)
If Not sRng Is Nothing Then
MyAdd = sRng.Address
Do
If tRng Is Nothing Then
Set tRng = sRng.Offset(, 1)
Else
Set tRng = Union(tRng, sRng.Offset(, 1))
End If
Set sRng = Rng.FindNext(sRng)
Loop While Not sRng Is Nothing And sRng.Address <> MyAdd
End If
If Not tRng Is Nothing Then
Clls.Offset(, 1).Value = Application.WorksheetFunction.Max(tRng)
Clls.Offset(, 2) = tRng.Cells.Count
Set tRng = Nothing
End If
Next Clls
End Sub