Dim arr, arr1, arr2, arr3 Dim i As Integer Dim j As Integer arr = Range("A2:B" & [a65536].End(xlUp).Row) arr1 = [e2:F8] ReDim arr2(1 To UBound(arr1, 1)) ReDim arr3(1 To UBound(arr1, 1), 1 To 3) For i = 1 To UBound(arr1, 1) arr2(i) = Mid(arr1(i, 2), 4, Len(arr1(i, 2)) - 4) + 0 For j = 1 To UBound(arr, 1) If arr(j, 1) = arr1(i, 1) Then arr3(i, 3) = arr3(i, 3) + arr(j, 2) End If Next Next For j = 1 To UBound(arr3, 1) arr3(j, 2) = arr3(j, 3) Mod arr2(j) arr3(j, 1) = arr3(j, 3) \ arr2(j) Next [g2].Resize(UBound(arr3, 1), 3) = arr3 Erase arr, arr1, arr2, arr3 End Sub