AutoFill for Repeating Groups of Numbers

[Jonezee1]

Hi,

I'm trying to fill Column A with the following series: A1=0, A2=0, A3=0, A4=0, A5=1, A6=1, A7=1, A8=1, A9=2, etc. In short 4 0's, 4 1's, 4 2's up to 255. AutoFill will not work for me for this. Is there a better way?? Thanks in Advance!!!

Chris

[Paul]

Hi Jonezee, and welcome to the forum.

Try this in A1 and fill down:

=FLOOR(ROW()-0.1,4)/4

[Jonezee1]

Paul,

THANK YOU for your fast reply & warm welcome!!!! Now I don't have to look like your avatar anymore!!!!

Chris