Count of duplictaes

  • Thread starter Thread starter Deepak
  • Start date Start date
D

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
 
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.
 
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
 
Back
Top