Pulling random columns

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

Hi,
Is there an automated way to pull 25 random rows out of an
excel list of about 11k rows of data? It's for audit
purposes.

Thank you,
Katie
 
One post is usually enough at least until you receive an answer.

Use Copy the list to a temporary page, use a helper column, put RAND() in
the first
adjacent cell, double click the lower right corner of the cell with the
formula to copy it down
11k rows. Now sort on the helper column and select the first 25 records..
 
Back
Top