Possible? -- RAND()

  • Thread starter Thread starter aapp81
  • Start date Start date
A

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,
 
You could try

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

this shou come up with random numbers from 65 onwards
which will fit into the chr() form
 
=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 said:
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
Click to expand...
creating financial statements
 
Back
Top