问Excel公式/Excel-宏/重复数据

EN

=SUMPRODUCT((A:A=123456)*(B:B="SGSINtest")*(C:C="delete")*(D:D=MAX(IF(AND(A:A=123456,B:B="SGSINtest,C:C=""delete"),D:D)))*(E:E))

Function rowWithHighestVF(productId As Long, contractId As String, typeOfChange As String) As Range
    Dim r As Range, validFrom As Date, maxVF As Date: maxVF = 0
    For Each r In UsedRange.Rows
        If r.Cells(1) = productId And r.Cells(2) = contractId And r.Cells(3) = typeOfChange Then
            validFrom = r.Cells(4)
            If validFrom > maxVF Then
               maxVF = validFrom 
               Set rowWithHighestVF = r
            End If
        End If
    Next
    If Not rowWithHighestVF Is nothing then rowWithHighestVF.Activate
End Function