Thread: How do I set up a formula to repeat 5 consecutive cells in a colum

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

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" <jbsand1001@discussions.microsoft.com> wrote in message
news:AB682648-07CD-4CAA-9064-E9B0F8CFEA37@microsoft.com...
> 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
>