Quote Originally Posted by sam2539
If the first cell in Column 1 is b2 and has the 20 names down to b21, and the next column is c2 and so on to d2, then where would I put the suggested formula. Sorry for my ignorance.
Right now it uses the entire column,change the columns or range as necessary,ie =INDEX($A$1:$A$9,RANDBETWEEN(1,COUNTA($A$1:$A$9)),1)