Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible? -- RAND()
hi, i've been playing around w/ the rand() func. but i need something a tad different... i either need it to generate random LETTERS from C - T or i need a MACRO will sort a column w/ the letters C - T randomly. if anyone can help out, i'd appreciate it! thanks, ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible? -- RAND()
You could try
= (int(rand()*26))+65 this shou come up with random numbers from 65 onwards which will fit into the chr() form |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible? -- RAND()
=CHAR(TRUNC(RAND()*18+67))
than drag fill down the column. However, this isn't a shuffle (includes all letters in random order with no repeats) of the letters C to T if you want a shuffle, put in the letters C to T in a column. In the adjacent column, put in =Rand(), fill down and then sort the two columns with the Rand() column as the key. -- Regards, Tom Ogilvy "aapp81" wrote in message ... hi, i've been playing around w/ the rand() func. but i need something a tad different... i either need it to generate random LETTERS from C - T or i need a MACRO will sort a column w/ the letters C - T randomly. if anyone can help out, i'd appreciate it! thanks, ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RAND() | Excel Worksheet Functions | |||
Rand between 1 and 50 | Excel Worksheet Functions | |||
how can i set up rand or rand between to give only -1 or 1? | Excel Worksheet Functions | |||
=INT(0+(1-0+1)*RAND()) wtf? | Excel Worksheet Functions | |||
RAND() | Excel Discussion (Misc queries) |