Forum Discussion
Rejisha
Jun 05, 2025Copper Contributor
random number generation
how to avoid repetition in random number generation
using the function "INT(RAND()*20)
few numbers are repeating and I need to avoid the repetition
kindly help
1 Reply
Sort By
- m_tarlerBronze Contributor
I think you want to have the number 1-20 randomly sorted?
=SORTBY(SEQUENCE(20),RANDARRAY(20))