How can I "randomize" a range of numbers? eg. column A contains no's 1-50. I want them arranged in column B in random order, and the same in column C (for column B), et cetera. Is there perhaps a formula?
Thanks.
How can I "randomize" a range of numbers? eg. column A contains no's 1-50. I want them arranged in column B in random order, and the same in column C (for column B), et cetera. Is there perhaps a formula?
Thanks.
maybe
=RANDBETWEEN($A$1,$A$50)
or
=RANDBETWEEN(1,50)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hello GUERCHARD, and welcome to the forum.
Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks