RejishaCopper ContributorJun 05, 2025random number generationhow to avoid repetition in random number generationusing the function "INT(RAND()*20)few numbers are repeating and I need to avoid the repetitionkindly help
1 ReplyReplies sorted by Newestm_tarlerBronze ContributorJun 05, 2025I think you want to have the number 1-20 randomly sorted?=SORTBY(SEQUENCE(20),RANDARRAY(20))
m_tarlerBronze ContributorJun 05, 2025I think you want to have the number 1-20 randomly sorted?=SORTBY(SEQUENCE(20),RANDARRAY(20))
