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
|