# Auto Group Fill in Sequence

1. ## 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!!!

2. ## 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 ?

3. ## 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. ## 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. ## 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. ## 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. ## Re: Auto Group Fill in Sequence

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

##### Users Browsing this Thread

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

#### 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