Results 1 to 5 of 5

Thread: Repeat Numbering for like ID's
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2017
    Location
    Chicago, IL
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Repeat Numbering for like ID's

    Hi, I have id's numbers that repeat and i need to count them with the same "row number" the formula I've come up with is: =if(b2=b1,"1",a1"+1"). each change in employee number it starts over to row number 1. what am i missing
    Row Number ID Number
    1 123421
    1 123421
    2 222323
    2 222323
    2 222323
    3 434344
    3 434344
    4 545443

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,743
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Repeat Numbering for like ID's

    I think this may be what you are looking for:
    Code:
    =if(b2=b1,a1+1,1)
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,225
    Post Thanks / Like
    Mentioned
    69 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Repeat Numbering for like ID's

    If you want this result, You must start with 1 in cell A1 and in cell A2 put the formula:

    =IF(B2=B1,A1,A1+1)

     AB
    11123421
    21123421
    32222323
    42222323
    52222323
    63434344
    73434344
    84545443


    ----
    if you want this, You must start with 1 in cell A1 and in cell A2 put the formula:


    =IF(B2=B1,A1+1,1)


     AB
    11123421
    22123421
    31222323
    42222323
    53222323
    61434344
    72434344
    81545443
    Regards Dante Amor

  4. #4
    New Member
    Join Date
    Dec 2017
    Location
    Chicago, IL
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Repeat Numbering for like ID's

    Thank you!!! worked!!

  5. #5
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,225
    Post Thanks / Like
    Mentioned
    69 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Repeat Numbering for like ID's

    I'm glad to help you. Thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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