Forum Discussion
Repeat each reference multiple times before refer to another 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 >".
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!
