Forum Discussion
How to repeat same number every n rows in the same column
Hi, I need to repeat the same number every n rows within the same column, any thoughts? Also, how can I do the same using a formula rather than a number? Also, and I think , slightly mor...
Hi, thanks for the answer!, but i think my issue is more complex, I already attached a excel doc answering mtarler, let me know if you cannot find the excel doc and I'll share a copy with you.
Ragards
Julian
Ragards
Julian
If without VBA
1) I'd create helper column (you may hide it) which fills down value in I15, other every 12 cell in column I could use reference on this helper column
2) To define an option I'd use not the cell property such as color, but some values, perhaps from drop-down list. Based on selected value you may do this or that calculations. To color the cell(s) you may use conditional formatting on the top.