jeudi 24 mai 2018

Excel Random Number Generator Without Producing Duplicates?

Example Screenshot

I have a column (D2:D49) using the code

=INT(RANDBETWEEN(0,51))

The idea is that this corresponds to playing card values from a deck.

The only issue is that numbers can appear more than once, meaning there is a chance of being dealt the exact same card (e.g. 4 of spades) twice in one hand, which is impossible - how can I amend the formula to avoid duplicates?




Aucun commentaire:

Enregistrer un commentaire