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.

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

"Alain" wrote:

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.

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 EditCopy
Then EditPaste SpecialValuesOK

--
Biff
Microsoft Excel MVP


"Alain" wrote in message
...
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.

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

"Sean Timmons" wrote:

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

"Alain" wrote:

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, 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).

"Sean Timmons" wrote:

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

"Alain" wrote:

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.

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

"T. Valko" wrote:

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 EditCopy
Then EditPaste SpecialValuesOK

--
Biff
Microsoft Excel MVP


"Alain" wrote in message
...
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.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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

"T. Valko" wrote:

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 EditCopy
Then EditPaste SpecialValuesOK

--
Biff
Microsoft Excel MVP


"Alain" wrote in message
...
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.