|
| 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
November 10th, 2008, 05:27 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
November 10th, 2008, 06:25 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
November 10th, 2008, 10:32 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
