Excel tricks-
I needed to generate fake data set for a project to verify the scalability of a db project. Need to create a string of random set of words in a cell. So here is my solution. It will okk for a cell that is no tblank in column A. It will index from cell A1 to A10 and create a random order of the indexed words in column B.


=IF(NOT(ISBLANK(A1)), INDEX($A$1:$A$10, RANDBETWEEN(1, ROWS($A$1:$A$10))))