adding a duplicate coolums into a new coloumn

[rouge0288]

I have 5 coloums in which the last three have numeric values. The first two coloums have name and country code. Now, The first two coloums have duplicate values but the rest of the corresponding columns have different numeriv values. What I want now is to add the numeric values of the coloumns of the duplicate data and want to display in the first row.
For ex
there are A = name , B= Country , C D and E contains different numeric values.
A and B have dupilcate data but different C, D and E values. Now I want to add up the numeric values of the dupilcate data and get it displayed in a new coloum in the first row of the duplicate data set. I hope am clear. please help.

[alvin-chung]

Hi, try upload a sample workbook for better illustration.
You may consider using pivot table?


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin