Insert two columns before the list you want to generate a random result
from. e.g. if your list is in A1:A10, insert two columns so your list
is in C1:C10. In cell B1, enter the formula "=rand()". Fill down to
B10. In cell A1, enter the function "=rank(B1,$B$1:$B$10,0)", and fill
down to A10. This will give each cell from A1 to A10 a unique number
(rank) from 1 to 10.

What this does is build in a random nature to any VLOOKUP reference for
the array which includes your list (in the example above, this array
would be $A$1:$C$10). Every time F9 is pressed, the ranking will
change. So, to get a random list, in any cell you like, type the
following:

=concatenate(vlookup(1,$A$1:$C$10,3,false),"
",vlookup(2,$A$1:$C$10,3,false)," ",vlookup(3,$A$1:$C$10,3,false),"
Ltd")

To make this far easier (I don't like typing in absolute cell
references), you could name your array. Note: The " " parts in the
formula are just there to put spaces in.

Hope this helps. In my experience, there's almost nothing that can't
be done in Excel. Persevere, and think outside the square. You'll
find a solution.

Regards,

random1970

Excel user (and enthusiast) for more years than I care to remember.


--
random1970
------------------------------------------------------------------------
random1970's Profile: http://www.excelforum.com/member.php...o&userid=32112
View this thread: http://www.excelforum.com/showthread...hreadid=518314