Possible? -- RAND()

[aapp81]

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,

 

[G Hicks]

You could try

= (int(rand()*26))+65

this shou come up with random numbers from 65 onwards
which will fit into the chr() form

 

[Tom Ogilvy]

=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

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,


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements