Count of duplictaes

[Deepak]

This is my original file

Col A Col B Col C Col D
Name Jan Feb Mar

Deepak 1 0
Deepak 2 1 3
Deepak 1
Tata 0 0 2
Tata 2
Ambani 5 2
Ambani 1



Need to add the count of duplicate - so the result should be as below

Name Jan Feb Mar

Deepak 4 1 3
Tata 2 0 2
Ambani 6 2


any help is appreciated in advance

Deepak

 

[muddan madhu]

Col E Col F Col G Col H
Name Jan Feb Mar

in cell F2 put this formula =SUMIF($A$2:$A$7,$E2,B$2:B$7) copy it down
and across.

 

[AnthonyHo2008]

No need to use formula in this case. You may consider to use the
"Consolidate" feature from the Data menu. Highlight all of the data and then
remember to select both "Top Row" and "Left Column" in the Label section.

Cheers.

AnthonyHo2008