Enter your data in A1:A5, then with A6:A31 blank, go to A32 and enter
=IF(A1<"",A1,"") then copy down as far as you'd like.



"jbsand1001" wrote in message
...
I am looking for a formula to repeat 5 concecutive cells either numerical
or
words in a column every 31st cell

For example:


A1= 1 A32=1

A2= Cost A33=Cost

A3= 5 A34=5

A4=Profit..etc. A35=Profit.etc.



Thank you,


Judd