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...
with 365 you have a lot of options. Here are a few:
=TOCOL(SEQUENCE(,3,1,0)*{3;7;6})=TOCOL(IF(SEQUENCE(,3),{3;7;6}))=CHOOSE(INT(SEQUENCE(9,,0)/3)+1,3,7,6)