vendredi 3 juin 2022

Generate equal number of numbers between interval

how to go about generating a column of numbers between a min and max value (inclusive), distributed equal number of times?

For example, generate integers between 1 and 5 in 600 cells in excel. The column will consist of 120 1's, 120 2's....and 120 5's in random order.

Any guidance is appreciated!




Aucun commentaire:

Enregistrer un commentaire