Forum Discussion
Repeating Numbers
Hi, Trying to repeat the same number (from an array) an X number of times. How do I go about this? I've seen some examples using the OFFSET function, but trying to do this by avoiding volatile fu...
For older versions of excel.
=IFERROR(INDEX($A$2:$A$4,ROUNDUP(ROW(A1)/3,0)),"")