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.
Last edited by AliGW; 12-28-2019 at 08:07 AM. Reason: Solved tag added - no need to edit thread title or add solved to post. Thanks.
For me. when I ran your code it took .34375 seconds
Yeah it gets really slow with 2000 numbers and more.Originally Posted by davesexcel
Last edited by FanAnd22; 12-28-2019 at 04:49 AM.
I think excel simply struggles to work fast as the numbers increase. So running it on multiple work books and then pasting everything together afterwards seems to be a more efficient way of running things
Thanks
try
Please Login or Register to view this content.
Thank you so much. This is 100 times faster..try
Please Login or Register to view this content.
It's really really fast. I Can't process the difference. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks