Random Name Generation

  • Thread starter Thread starter pkbro
  • Start date Start date
P

pkbro

Okay, here's a tricky question. I'm trying to get Excel to Concatenate
Random Cells. Is there any way to do this?

What I would like it to do is basically this: A1 is "B", A2 is "C", A3
is "R", B1 is "at", B2 is "an", and B3 is "ob". I'm trying to create is
a command that would do the following:

=CONCATENATE(A(INT(RAND()*(3-1)+1)),B(INT(RAND()*(3-1)+1)))

I tried this conbination command and Excel wigged out. What I was
looking for is a field that could return *ANY* of the following, chosen
at random: Bat, Cat, Rat, Ban, Can, Ran, Bob, Cob, Rob.

Any suggestions on how to pull this off?
 
Why not just enter all these possibilities in a column, and then refer to
the range with a formula such as this:

=INDEX(A1:A9,INT(RAND()*9)+1)

Then, at each hit of <F9> (calculate key), you'll get a new selection.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Back
Top