Random Numbers

K

Karen

Hello. I've tried the search function on the board, but did not find what I
was looking for. I am trying to create 99 two-digit random numbers between 00
and 99 in Excel. I tried to use the data analysis under tools, but I don't
think that I am puttnig in the correct info. It does not necessarily matter
if the numbers change each time I hit F9, because I am going to print them
out anyway. Can anyone assist me? Thank you.
 
P

Peo Sjoblom

Do you want 1-99 in a column in what seem to be random order with no repeated
numbers? if so put 0 in the first cell and 1 in the second cell, copy down
and fill up to 99, then insert a help column next to it and put =RAND() in
the first cell, copy down the formula all the way to 99, then select both
columns, do data>sort and sort by the help column with the formulas, finally
delete the help column
Of course this si somewhat of a pseudo sort since all the numbers are unique
but something most people seem to want


Regards,

Peo Sjoblom
 
K

Karen

Thank you for the replies. I'll try the suggestions and see if I get what I
am looking for. Thanks again.
 
Top