| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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. "jbsand1001" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) | |||
| Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
| to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
| How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions | |||
| A formula to check differrent cells | Excel Worksheet Functions | |||
Linear Mode
