An alternative ..
Assume names in A2:A17
In B2: =RAND()
In C2: =INDEX($A$2:$A$17,RANK(B2,$B$2:$B$17))
Select B2:C2, copy down to C17. Hide away col B.
C2:C17 will return a random shuffle of the names in A2:A17.
Just press F9 key to regenerate. You don't need the command button.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TotallyConfused" wrote:
I need to shuffle a list of names between rows 2 and 17. I also need a
command button so that when I click on button names will shuffle through
without duplicating or getting 0s. I tried Index Rand and RandBetween and
not being successful. Can someone please help me. I have seventeen names in
Column A. I want the sames names to be shuffled in column B. Thank you in
advance for any help.