I have an Excel spreadsheet and am trying to make it generate the numbers in random order. Anybody able to help me? I've used the function =rand()* then the number of items but it won't allow me to sort based on that function because everytime the random numbers re-randomize. Please Help!
2006-12-12 05:52:09 · 4 answers · asked by MiMi 3 in Computers & Internet ➔ Software
Copy them over as paste special values, and then sort.
Also, have you tried using the Excel add in pack for analysis? (This is a Random Number Generator, rather than sorting in random order.)
If helpful see site below.
If you don't have the add-in you just go to Microsoft and download it, I just did it recently.
2006-12-12 06:02:27 · answer #1 · answered by QueryJ 4 · 1⤊ 0⤋
That is a good question.
now I have to tell you that RAND() function will generate a random number at each calculation, means you will have a random order every time you change a cell value (Or press F9).
To do a random order, you will need VBA to do it.
mail me here if you are interesting in VBA (Macro), I will be pleased to write some code for you.
Enjoy my profile, I am the VBAXLMan
2006-12-12 17:24:42 · answer #2 · answered by Anonymous · 0⤊ 1⤋
RAND() will give you a random number between 0 and 1. RANDBETWEEN(bottom,top) lets you specify the bottom and top limits. So if you want a number between 10 and 20, you would use RANDBETWEEN(10,20). If you get an error when using RANDBETWEEN, you need to install the Analysis toolpack: Tools > Add-ins > Analysis ------------------------------------ You shouldn't have to have the disk as far as I know. It should be available from the Tools menu.
2016-05-23 00:07:33 · answer #3 · answered by ? 4 · 0⤊ 0⤋
You can create the list as you said, and then copy that whole column and paste it using Paste Special and then choose Values. That way it will paste the values you created but they will not be in the form of a formula anymore, and you can sort them.
2006-12-14 02:33:10 · answer #4 · answered by Lowa 5 · 1⤊ 0⤋