عليكم السلام
إذا كنت منفتحاً على استخدام ماكرو فإليك هذا وإلا ....
Sub test()
Dim a, w
Dim T As String
Dim i&
a = Sheets("aaa").Cells(1).CurrentRegion
With CreateObject("scripting.dictionary")
For i = 2 To UBound(a)
T = a(i, 2) & a(i, 3) & a(i, 4)
If Not .exists(T) Then
.Add T, Array(.Count + 1, a(i, 2), a(i, 3), a(i, 4), a(i, 1), a(i, 1) + IIf(a(i, 1) = 1, 199, 99))
Else
w = .Item(T): w(5) = w(4) + 99: .Item(T) = w
End If
Next
Sheets("aaa").Cells(2, 9).Resize(.Count, UBound(a, 2) + 2) = Application.Index(.items, 0, 0)
End With
End Sub