hello, Does anyone know the formula for random name selection using one column? thanks,
P perlaparedes Aug 17, 2006 #1 hello, Does anyone know the formula for random name selection using one column? thanks,
B Biff Aug 17, 2006 #2 One way: Assume you have 15 names in the range A1:A15. =INDEX(A1:A15,INT(RAND()*15)+1) Will return a different name (although repeats are possible) every time a calculation is triggered. To make a new selection just press F9. Biff
One way: Assume you have 15 names in the range A1:A15. =INDEX(A1:A15,INT(RAND()*15)+1) Will return a different name (although repeats are possible) every time a calculation is triggered. To make a new selection just press F9. Biff
