vendredi 20 avril 2018

how to generate random number with no repeat above limit?

I think I've hit the upper limit level for random generating numbers... Is there any workaround for this? I need to generate 10 unique random numbers in one formula/string and it always must be a 19 digit number.

I have this: =TRUNC (RAND() * (9999999999999999999 - 1) + 1)

but spreadsheet rewrites it to: =TRUNC (RAND() * (9999999999999990000 - 1) + 1) so I guess the limit is 9999999999999990000. is there a bypass? thx




Aucun commentaire:

Enregistrer un commentaire