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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top