Count formula
 

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

Count formula
 

SORRY IT GOT ACCIDENTLY POSTED TWICE

"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

Count formula
 

Data doesn't visually line up, so can't check out your totals
to your data, but suggest you try a Pivot Table.

Equal Width Cells per Column
Location: http://www.mvps.org/dmcritchie/excel/equicols.htm

Using Pivot Tables in Microsoft Excel
http://peltiertech.com/Excel/Pivots/pivottables.htm

Contextures -- Excel Tips and Techniques
http://www.contextures.com/tiptech.html

--
HTH,
David McRitchie
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm



"Deepak" wrote in message ...
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