Count formula

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