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
Bookmarks