Hi-
What formula can I use in excel to randomly generate numbers of between 1-150, and not repeat a number twice? usingdoes not work. It repeats numbers.Please Login or Register to view this content.
Thansk
Hi-
What formula can I use in excel to randomly generate numbers of between 1-150, and not repeat a number twice? usingdoes not work. It repeats numbers.Please Login or Register to view this content.
Thansk
You need a shuffle routine. Here is a link to some code I posted a few years ago.
http://www.excelforum.com/excel-form...ing-false.html
To use it, fill a row with the numbers 1 through 150 (let's say A1:ET1). Highlight A2:ET2 and type =Shuffle(A1:ET1) and then hit Ctrl-Shift-Enter. The second row will now have the numbers shuffled.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
The birthday problem, eh?
With an array formula:
Or, with a UDF.Please Login or Register to view this content.
Either of those do it for you?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks