Auto Group Fill in Sequence

[vhgong]

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

[Special-K]

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 ?

[vhgong]

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?

[Special-K]

Now you've explained it clearly, yes.

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

[vhgong]

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

[Special-K]

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.

[vhgong]

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