+ Reply to Thread
Results 1 to 7 of 7

Auto Group Fill in Sequence

  1. #1
    Registered User
    Join Date
    07-20-2016
    Location
    Seattle
    MS-Off Ver
    2010
    Posts
    9

    Auto Group Fill in Sequence

    I am having a tough time figuring out or even describing out the issue here.
    But here goes.....

    I have a set of input data as below

    123a
    234c
    342d
    674c
    876e
    765f
    123f
    764a
    674q
    876r
    654e
    987w

    I am trying to add in a second column that will autofill in by sequence and group

    So the output will be


    123a 1
    234c 1
    342d 1
    674c 2
    876e 2
    765f 2
    123f 3
    764a 3
    674q 3
    876r 4
    654e 4
    987w 4

    Help!!!
    Last edited by vhgong; 05-15-2019 at 10:26 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    MS Office Excel 2007
    Posts
    6,951

    Re: Auto Group Fill in Sequence

    I can't see a pattern here.

    123a 1
    234c 1
    342d 1

    I get that but

    Why is 674c listed as 2?

    Specifically what is the group?
    123 ?
    a ?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    07-20-2016
    Location
    Seattle
    MS-Off Ver
    2010
    Posts
    9

    Re: Auto Group Fill in Sequence

    674c is just example of data that i have.

    I am trying to auto-populate the sequence in groups of 3.



    Does that make sense?

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    MS Office Excel 2007
    Posts
    6,951

    Re: Auto Group Fill in Sequence

    Now you've explained it clearly, yes.

    in B1
    =QUOTIENT(ROW()-1,3)+1
    and copy down the column

  5. #5
    Registered User
    Join Date
    07-20-2016
    Location
    Seattle
    MS-Off Ver
    2010
    Posts
    9

    Re: Auto Group Fill in Sequence

    My Goodness......you are good!!!! You are so good!!!
    You have save me a lot of hassle.
    Thank you soooo much!!!!

  6. #6
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    MS Office Excel 2007
    Posts
    6,951

    Re: Auto Group Fill in Sequence

    If you start moving the data around then the formula may not do what you want as its dependent on which row it is on, e.g.
    123a is group 1
    If you move it to another row the group number will change.
    If you need to maintain the group numbers use copy the formula and Paste Special values over the top of the formula so the value remains the same.

  7. #7
    Registered User
    Join Date
    07-20-2016
    Location
    Seattle
    MS-Off Ver
    2010
    Posts
    9

    Re: Auto Group Fill in Sequence

    Understood. The format will always be the same.
    Thanks so much again.

+ 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