RANDUNIQUE

RANDUNIQUE-v2.txt

// v2
/* UPDATE 13/02/2022
Added columns argument and made each optional
*/

// Returns an array of unique random numbers

RANDUNIQUE =

LAMBDA([rows],[columns],[min],[max],
             INDEX(
             SORTBY(
                    SEQUENCE(max+1-min,,min),
                    RANDARRAY(max+1-min)
                   ),
             SEQUENCE(rows,columns)
                  )
)

RANDUNIQUE.txt

// v1
// Returns an array of unique random numbers

RANDUNIQUE =

LAMBDA(rows,min,max,
       INDEX(
             SORTBY(
                    SEQUENCE(max+1-min,,min),
                    RANDARRAY(max+1-min)
                   ),
             SEQUENCE(rows)
            )
)      

Great