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)