In Google Sheets, I want to generate a random number representing a playing card. I want to randomly choose five DIFFERENT cards, that are represented by the numbers 1 through 52. The first number is in cell J30
, the second in J31
and so on.
I thought about using RANDBETWEEN()
with IF
statements, but that didn't work for me.
I expect the output to have no numbers that are equal to each other. If it is possible to make this expandable, that would be nice.
Aucun commentaire:
Enregistrer un commentaire