The Excel functions for generating random ... The RANDARRAY function allows you to generate a sequence of random numbers without using the fill handle or copying and pasting a formula.