Hi, I would like to know if Excel can randomly select a string from a given list.
S SKA Aug 14, 2004 #1 Hi, I would like to know if Excel can randomly select a string from a given list.
M Myrna Larson Aug 14, 2004 #2 Let's say your list is in A1:A100 =INDEX(A1:A100,INT(RAND()*100)+1) If you have the ATP loaded, you could use =INDEX(A1:A100,RANDBETWEEN(1-100))
Let's say your list is in A1:A100 =INDEX(A1:A100,INT(RAND()*100)+1) If you have the ATP loaded, you could use =INDEX(A1:A100,RANDBETWEEN(1-100))
