Forum Discussion
Repeat each reference multiple times before refer to another row
Hi all,
Basically a simple copy paste would solve this, but would take hours.
Please help how to make each number repeated 7 times before referring to next row.
MFY92 This can be done using some of the same techniques outlined in my answer to your previous question: FILL SERIES BASED ON ABOVE FORMULA
=IFERROR(INDEX($P$2:$P$4, ROUNDUP((ROW()-ROW($R$1))/7, 0)), "< End of data >")Change $P$2:$P$4 to reference your entire range of data in column P.
Enter the first formula in cell R2, then drag/copy down until it returns "< End of data >".
3 Replies
MFY92 This can be done using some of the same techniques outlined in my answer to your previous question: FILL SERIES BASED ON ABOVE FORMULA
=IFERROR(INDEX($P$2:$P$4, ROUNDUP((ROW()-ROW($R$1))/7, 0)), "< End of data >")Change $P$2:$P$4 to reference your entire range of data in column P.
Enter the first formula in cell R2, then drag/copy down until it returns "< End of data >".
- Yes! Just need to modify something. Thank you sir!
MFY92 You're welcome! Sorry, I forgot to mention the denominator used in (ROW()-ROW($R$1))/7 indicates the number of repeats, so if you wanted only 6 repeats, change the 7 to 6. Cheers!
