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

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
 
D

Dave R.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set up a formula to repat 5 consecutive cells in a colum. 2
Cell Reference in a Formula 2
Creating a formula relating to several cells 2
having problems with a multiple conditions nesting formula 3
Counting cells in a range per multiple criteria . . . 10
Zero and Empty cells, What to do 7
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
How do I count # of cells with same value other column? 4

Top