S
Sethnstorm
I am looking to "shuffle a deck" of 100 numbers in a list and only hav
this list reshuffle when I hit a button (not everytime a re-calculatio
is done within the worksheet). So far I have been able to get th
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 C10
respectively
This does the job, but everytime excel recalculates, the shuffl
changes. How do I avoid this?
Set
this list reshuffle when I hit a button (not everytime a re-calculatio
is done within the worksheet). So far I have been able to get th
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 C10
respectively
This does the job, but everytime excel recalculates, the shuffl
changes. How do I avoid this?
Set