Hello:

Get rid of column B. Just the 100 numbers in A1:A100 and in B1:B100 put
the =rand() formula.

Now just sort A1:B100 on column B. Each time you want a new order just
sort again.

For a more automated featu

You can record a macro to this if you wish. Just turn on the macro recorder
and go through the steps of selecting the area and then select Sort and
column B.

You can put a button on the spreadsheet from forms toolbar and assign the
macro to it. Then you just click.


Pieter Vandenberg

Sethnstorm wrote:

: 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