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.
My formula worked though it does not delete the row.
that is fine.
but I am sure there is another better way of...