| Home |
| Search |
| Today's Posts |
|
#1
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove dashes between letters and between letters and digits | Excel Worksheet Functions | |||
| how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
| How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
| Speed Search in pick list by typing only first few letters | Excel Discussion (Misc queries) | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Linear Mode
