XL97 question on generating random numbers

Topic

New Reply

How do I generate random numbers 0-9 in ten adjacent cells, such that each number appears exactly once? TIA. Joe

Reply | Quote

Replies

I have had to do something like this myself. The way I did it is I am sure not the BEST] way. What I did is put my numbers 0 through 9 in a column. I then generated a random number in the adjacent column. Then select BOTH columns and sorted using the random number column.

Now, if you have several of these “random” strings you need to generate, you can copy the random number column and do a “paste special” with the values only next to your second, third, fourth….. strings of 0 through 9. Each “paste special” will generate i different set of random numbers.

What I would like to be able to do is take a list of 10 names and have Excel automatically “randomize” those names. So far I have been too lazy to write a macro to do this. Guess I am hoping that there is some magical easy way to do this.

Good Luck.
Larry P

Reply | Quote

Are you trying to create random numbers or a sequence? They aren’t the same thing. Numbers 0-9 are a sequence. Numbers like 15, .0597, 240 are random.

Reply | Quote

Can’t speak for Joe but what I would like to do is take a list of 10 names and put them in random order. My prior post describes how I have done this in the past. Was just wondering if there was a better way? Thanks for any help on this.

Reply | Quote