I am looking to "shuffle a deck" of 100 numbers in a list and only have
this list reshuffle when I hit a button (not everytime a re-calculation
is done within the worksheet). So far I have been able to get the
following:
Column A1:A100 = the list of values to be sorted
Cell B1 =INDEX(A:A,RANK(C1,$C$1:$C$100))
Cell C1 =RAND()
Cells B1 and C1 are then cut and pasted down to cells B100 and C100
respectively
This does the job, but everytime excel recalculates, the shuffle
changes. How do I avoid this?
Seth
--
Sethnstorm
------------------------------------------------------------------------
Sethnstorm's Profile:
http://www.excelforum.com/member.php...o&userid=22571
View this thread:
http://www.excelforum.com/showthread...hreadid=523826