If it is Excel - do you know the start and end row number of the column? Then you can set up Random number generator: =TRUNC(RAND()*(High-Low)+Low) Note: Low & High are the column row references.
You now may use this number as the random row number & get the corresponding value.
Last Wiki Answer Submitted: November 25, 2008 10:37 pm by SbElectric2,510 pts.
All Answer Wiki Contributors: SbElectric2,510 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
Can you tell us what application and version you are using please?
Yes, please provide more details, as this could probably be done in different ways depending on the database.