In Cells A1:J1000000 I have a total of 10,000,000 different numbers.
I would like to randomly select (without duplication) the numbers from A1:J1000000 and move them into cells L1:U1000000 starting with L1 down to L1000000, then M1:M1000000 etc until all the numbers have been randomly selected and moved.
Hello ssjagger,
Maybe you do not realize that the exponential growth of variables within 10 million cells would be so vast, that it could require trillions of Cells which Excel would never be able to cope with.
Sorry, I believe it is impossible.
Regards.
Last edited by Winon; 07-31-2016 at 05:00 PM. Reason: Grammar
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Not only that but random selection without duplication is not random selection
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
What if I reduced my numbers to 1.5M numbers instead?
Cell A1:C500000 randomly selected with out duplication into cells E1:G500000?
Hello ssjagger,
Sorry, but even if you did that, the same answers remain valid as provided in Posts #'s 2 and 3.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks