Creating an ascending number sequence in groups of 6

Need help from the Excel gurus ASAP! Is there a way to automatically create a number sequence in a column like this:

111111222222333333444444555555666666

i.e., Ascending numbers in groups of 6. Trying automate the page numbers of personal ads in a magazine (there's six per page). Thanks!

one way:

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

or

=ROUNDUP(ROWS($A$1:$A1)/6,0)

copied down

Try:

=CEILING(ROWS($A$1:$A175)/6,1) copied down

175 is smallest number divisible by 6 (your group size) that will roundup to 30 and when copied down, will still result in 30 until it reaches 180.... then moves to 31, etc...

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Copy the column and then select the top cell and go to Edit|Paste Special and select Values... Click Ok...

munyaj welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.