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...