Forum Discussion

JanSimoni's avatar
JanSimoni
Copper Contributor
Dec 10, 2020

9 random selections

I need to make 9 random selections of 9 different numbers from 1-100. It is important that the same number does not show twice. Any ideas? Thanks

excel
Formulas and Functions

1 Reply

  • mathetes's avatar
    mathetes
    Silver Contributor
    Dec 10, 2020

    JanSimoni 

     

    I would do something like the attached. It could be made more sophisticated, but this is a quick and dirty solution making use of the recently available UNIQUE function to assure no duplicates.

     

    Hit F9 to generate a new list. The highlighted cells are your unique nine.

Resources