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

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

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