Thread: Count formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Deepak Deepak is offline
external usenet poster
 
Posts: 47
Default 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