RejishaCopper ContributorJun 05, 2025random 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 Show More
m_tarlerBronze ContributorJun 05, 2025I think you want to have the number 1-20 randomly sorted?=SORTBY(SEQUENCE(20),RANDARRAY(20))
