Count of duplictaes
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 of duplictaes
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 |
Count of duplictaes
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 |
All times are GMT +1. The time now is 09:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com