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
|