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.