ExcelBanter - How do I set up a formula to repeat 5 consecutive cells in a colum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I set up a formula to repeat 5 consecutive cells in a colum (https://www.excelbanter.com/excel-worksheet-functions/8848-how-do-i-set-up-formula-repeat-5-consecutive-cells-colum.html)

jbsand1001

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

All times are GMT +1. The time now is 05:51 PM.