random letter generation
nevermind i got it. thanks
"Ann" wrote:
thanks! is there an easy way to get the 3 letters in 1 cell?
"Bernie Deitrick" wrote:
Ann,
In cells A1:A21 enter your letters B - Z.
In cells B1:B21 enter the formula
=RAND()
In cell C1, enter the formula
=INDEX($A$1:$A$21,MATCH(LARGE($B$1:$B$21,ROW(A1)), $B$1:$B$21,FALSE))
and copy down to C2:C3.
Press F9 to get a new batch of letters...
Bernie
MS Excel MVP
"Ann" wrote in message
...
i'm trying to do a random letter generation, can this be done with a formula?
i need 3 random letters, which don't repeat and cannot include vowels - so
only 21 letters. or, can i use the random number generator somehow?
tia
|