+ Reply to Thread
Results 1 to 3 of 3

Reset count on name change

  1. #1
    Registered User
    Join Date
    09-24-2012
    Location
    ar
    MS-Off Ver
    Excel 2007
    Posts
    4

    Reset count on name change

    Col A Col B

    Bob 1
    Bob 2
    Bob 3
    Bob 4
    Bob 5
    Bob 6
    Bob 7
    Bob 8
    John 1
    John 2
    John 3
    John 4
    Joe 1
    Joe 2
    Joe 3
    Joe 4
    Joe 5
    Joe 6
    Joe 7


    I want to get column B. Basically count sequentially until there is a name change, then restart the count. Any ideas?

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Reset count on name change

    Cell B1 = 1
    Cell B2 to down =IF(A2=A1,B1+1,1)

  3. #3
    Registered User
    Join Date
    09-24-2012
    Location
    ar
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Reset count on name change

    Thanks, perfect.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1