H hulton Nov 10, 2008 #1 I would like to randomly pick letters from A to Z each time I ask the sheet to get a new letter
D David Biddulph Nov 10, 2008 #3 Doesn't that give half the probability for A or Z compared with the other letters? =CHAR(RANDBETWEEN(65,90)) if you've got ATP installed, or =CHAR(INT(RAND()*26)+65) or possibly just =CHAR(RAND()*26+65)
Doesn't that give half the probability for A or Z compared with the other letters? =CHAR(RANDBETWEEN(65,90)) if you've got ATP installed, or =CHAR(INT(RAND()*26)+65) or possibly just =CHAR(RAND()*26+65)
