add duplicate.

  1. srizki

    Sum Duplicate

    I have Customer ID in colum A, Name in column B, and amount in column C. I want to add up duplicates and delete one of the duplicate row. Thanks My formula worked though it does not delete the row. that is fine. =IF(AND(A2=A1,B2=B1),C2+C1,"") but I am sure there is another better way of...

Some videos you may like

This Week's Hot Topics