View Single Post
  #1   Report Post  
jbsand1001
 
Posts: n/a
Default 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