Forum Discussion
Solved
Who can explain this to me?
Who can explain this to me? I used the formula =UNIQUE(RANDBETWEEN(9788723527370120, 9788723527370990)) DBETWEEN(9788723527370120, 9788723527370990))
Let's say you want 100 random numbers, but list only the unique values:
=UNIQUE(RANDARRAY(100,1,9788723527370120,9788723527370990,TRUE))
Warning: keep in mind that ALL numbers will end in 0 because your numbers have 16 digits but Excel only displays 15 significant digits. Why not generate random numbers between 120 and 990?
