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...