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?
10 Replies
- This number should not have come twice if the range in the Unique formula had been between say A1 to A500. You are using Unique in each cell. That is why they can repeat in the list.
