I need a list of 210 random numbers in Calc, whether integers or otherwise doesn’t matter, as long as none of the numbers repeat i.e there are no duplicate numbers in the list.
I read a tutorial that the RAND() function was the one to use to do this, and have used the function accordingly.
However I have found repetitions of certain numbers in my results- how do I prevent this from happening?
I must admit I have very little knowledge of how the randomisation process works…
Attached is a document containing two columns, 1 with the list of numbers generated using RAND(), the other confirming duplicates of the first list.
@dscheikey Here is the referent screenshot I mentioned:
(Edit: activated screenshot -AK)