How to fill series with consecutive (but repetitive) numbers

[iliasark]

Dear All,

I need to fill down a column with numbers (from 1 to 100 for istance), but they are not 'purely consecutive' one another but with double or triple of the same numbers, like A1=1 - A2=1 - A3=1 , A4=2 A5=2 - A6=2 , A7=3 - A8=3 - A9=3 and so on...
How can I fill down the series in a succession like this one? Will I need a formula for it instead?

apreciate your help, thank you!

[zbor]

Something like this:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Norie]

Here's a formula for A1 which you can copy down as far as needed

=CEILING(ROW()/3,1)

Here's code to insert the fomula then replace it with the result.

Please Login or Register  to view this content.