If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pick from letters A-Z?
I would like to randomly pick letters from A to Z each time I ask the sheet
to get a new letter |
#2
|
|||
|
|||
pick from letters A-Z?
Try
=CHAR(ROUND(RAND()*25+1,0)+64) "hulton" wrote: I would like to randomly pick letters from A to Z each time I ask the sheet to get a new letter |
#3
|
|||
|
|||
pick from letters A-Z?
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) -- David Biddulph "Sheeloo" ="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in message ... Try =CHAR(ROUND(RAND()*25+1,0)+64) "hulton" wrote: I would like to randomly pick letters from A to Z each time I ask the sheet to get a new letter |
Thread Tools | |
Display Modes | |
|
|