Generate Random Numbers Between 0-9

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

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?