• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count names at the end of each name change

R

razaas

Member
I have data in 3 columns of my sheet (Col A to C) . In (Col D) I need a formula to count all entries of (Col C) which has same name. Suppose C1 to C5 has same name the result should be 5 but the result should appear in D5 only and D1 to D4 should be blank.

The required formula should count the entries with same name but show the result only in the last row before the name change.

Hope I explained clear enough. Any help is highly appreciated.
 
D2: =IF(C2<>C3,COUNTIF($C$1:C2,C2),"")

Copy down


If the values can be repeated later in column C change to

=IF(C2<>C3,COUNTIF(C:C,C2),"")
 
Hui,


As usual quick and perfect solution, thanks a lot. Values in column C does not repeat later so i have used the first Formula and it works perfectly. Thanks again.
 
You must log in or register to reply here.
Back
Top