Random Numbers
 

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.

=int(rand()*100)
but could have repeats of the ame number


"Karen" wrote in message
...
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.

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 datasort 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

"Karen" wrote:

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.

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

"Peo Sjoblom" wrote:

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 datasort 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

"Karen" wrote:

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.