Find duplicate rows based on two column values and group

Originally Posted by kevivu

Dear All,

In the attached excel... i need to find the duplicate records based on COLUMN B & COLUMN E, if there are matching records, I have to sum the value present in COLUMN C for that combination and keep only one record.

Missread...
Replace 9 with 3

            Else
                a(.Item(txt), 9) = a(.Item(txt), 9) + a(i, 9)
            End If

to

            Else
                a(.Item(txt), 3) = a(.Item(txt), 3) + a(i, 3)
            End If