MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Random text


Posted by Roger McCarthy on July 05, 2001 3:07 AM

I want to insert a random text generated from an excel table listing dummy names but can't seem to find a function to do it.

e.g. I want cell A1 to contain a random name taken from a table of names in cells C1 to C227 and be able to change the name to another one randomly selected from from C1 to C227 by recalculating/F9 just as if the text was a random number generated using the RAND function.

Can anyone help with this? (I'm a proficient excel user but can't write Visual Basic and rarely attempt macros so a non-techy answer would be appreciated)

Cheers,

Roger


Posted by Dax on July 05, 2001 5:17 AM

Try this formula: -
=OFFSET($C$1,INT(RAND()*227),0)

Dax.