dimanche 6 janvier 2019

Generate Multiple Different Random Numbers

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