Thread: Nine random and unlike numbers
View Single Post
  #2  
Old 01-29-2006, 12:21 PM
daddylonglegs's Avatar
daddylonglegs daddylonglegs is offline
Forum Moderator
  
Join Date: 14 Jan 2006
Location: England
MS Office Version:2002 (work), 2003 & 2007 (home)
Posts: 6,557
daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding daddylonglegs Has a higher level of understanding
You can do it this way

put this formula in A1

=RAND()
and copy down to A9

in B1 use this formula

=RANK(A1,A$1:A$9)
copy down to B9

B1:B9 should now show 1-9 in random order, hide column A if desired.

Note: values will change every time sheet recalculates
Reply With Quote