Find duplicate rows based on two column values and group

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

Please see the attachment for better understanding.

Expecting an early response..

Thanks.

[jindon]

Try

Please Login or Register  to view this content.

[kevivu]

First of all thanks for your quick response..

I have tried this code, but its only removing the duplicate row and giving any output.

[jindon]

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

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[kevivu]

Thanks a lot Jindon... it works fine... you are really a super star.....thanks a million...