# Auto Group Fill in Sequence

• 05-15-2019, 10:23 AM
vhgong
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!!!
• 05-15-2019, 10:29 AM
Special-K
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 ?
• 05-15-2019, 10:50 AM
vhgong
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?
• 05-15-2019, 11:00 AM
Special-K
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
• 05-15-2019, 11:03 AM
vhgong
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!!!!
• 05-15-2019, 11:11 AM
Special-K
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.
• 05-15-2019, 11:17 AM
vhgong
Re: Auto Group Fill in Sequence
Understood. The format will always be the same.
Thanks so much again.