If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|