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.



On Jan 21, 12:19*am, Deepak wrote:
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

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


"Deepak" wrote:

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