Re: Nine random and unlike numbers
- From: daddylonglegs <daddylonglegs.22emnm_1138551900.9949@xxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 29 Jan 2006 10:21:54 -0600
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 *** recalculates
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30486
View this thread: http://www.excelforum.com/showthread.php?threadid=506159
.
- Follow-Ups:
- Re: Nine random and unlike numbers
- From: Karoo News
- Re: Nine random and unlike numbers
- Prev by Date: Re: How do i SUM data in Excel ex:email that contains "Numbers and Text"???
- Next by Date: Re: Nine random and unlike numbers
- Previous by thread: Loading website from userform
- Next by thread: Re: Nine random and unlike numbers
- Index(es):
