Repeat Cell Data in Ranges

[Alain]

I know how to autofill in Excel but haven't been able to autofill 1,1,1,1,(up
to 50 row cells) and then 2,2,2,2 (for the next 50 cells), then 3,3,3,3 and
so forth up to 83,83,83,83,.... In other words, I want that sequence to
increase by 1 every 50 cells from number 1 to 83. Any help with this would be
greatly appreciated.

 

[Sean Timmons]

Well, a thought would be to go 1 to 83 as a fill, then copy and paste it.
50*83 = 4150 cells long... Then, just sort by the column...

 

[T. Valko]

Try this:

83 numbers repeated 50 times each = 4150 rows.

Assume you want the numbers entered in the range A1:A4150.

Enter the range A1:A4150 in the name box then hit enter. The name box is
that little "box" immediately above the column A header.

Type this formula:

=CEILING(ROWS(A$1:A1)/50,1)

Then hold down the CTRL key then hit ENTER.

This will fill the range A1:A4150 with the sequence of numbers. With this
range still selected do this:

Goto Edit>Copy
Then Edit>Paste Special>Values>OK

 

[Alain]

Thank you for answering my question Sean but I am not sure I understand what
you mean exactly. Could you please explain in more detail what you meant with
the formula as if to a novice as I am somewhat one? Thank you. Alain

 

[Alain]

Sean, I might've phrased my question wrong. I am trying to have all these
cells (1,1,1,...2,2,2,2....3,3,3,3,3) repeated 50 times for each number all
in one column going down (say column A).

 

[Alain]

Thank you to both for answering my question.
T.Valko, I tried what you suggested and it worked. Thanks a bunch. Alain

 

[T. Valko]

You're welcome. Thanks for the feedback!