Hi
I have a spreadsheet that generates numbers that are non repetitive for a defined set. E.g It creates x non repeated numbers for every y amount of numbers. I can change the settings so can do as many as i need. I can also set the min and max number like with the Rand() function.
I can have a list of 1000 numbers and for every 10 numbers there are no repetitions.
The only problem is that its incredibly slow. Is there a way to improve this?
Please Login or Register to view this content.
Bookmarks