Generate Random Numbers Between 0-9

**Richard Buttrey** · 02-01-2009, 03:42 PM

Hi,

Probably the easiest way is to list your numbers 0-9 in one column and alongside each of them in another column put the formula:

=RANDBETWEEN(0,9)

Now just sort the two columns using the random number as the key.

You could achieve the same sort of thing with a macro if you didn't want to see the 'workings'

HTH

**shg** · 02-01-2009, 03:46 PM

I would use RAND rather than RANDBETWEEN in the sort key column.

**VBA Noob** · 02-01-2009, 03:49 PM

dreicer_Jarr,

FYI

Richard forget to mention you need to install the Analysis ToolPak add-in before you can use Randbewteen.

Edit

Unless you have xl07

VBA Noob

**daddylonglegs** · 02-01-2009, 03:58 PM

I presume this is related to something called "The Superbowl", whatever that is.......

This is one way to achieve what you want without helper cells.....

In A1

=INT(RAND()*10)

in A2

=SMALL(IF(ISNA(MATCH({0,1,2,3,4,5,6,7,8,9},A$1:A1,0)),{0,1,2,3,4,5,6,7,8,9}),INT(RAND()*(10-ROWS(A$2:A2))+1))

confirmed with CTRL+SHIFT+ENTER and copied down to A10

**splatz** · 11-29-2012, 06:02 PM

Originally Posted by daddylonglegs

I presume this is related to something called "The Superbowl", whatever that is.......

This is one way to achieve what you want without helper cells.....

In A1

=INT(RAND()*10)

in A2

=SMALL(IF(ISNA(MATCH({0,1,2,3,4,5,6,7,8,9},A$1:A1,0)),{0,1,2,3,4,5,6,7,8,9}),INT(RAND()*(10-ROWS(A$2:A2))+1))

confirmed with CTRL+SHIFT+ENTER and copied down to A10

I was able to use this formula for the rows going down the side, but when I tried to change it for the columns going across the top, numbers kept repeating. Any suggestions?