View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tammy Tammy is offline
external usenet poster
 
Posts: 145
Default Randomly select records

Hi,
I have read a previous post and thought I could figure this out, but I'm
having a hard time understanding what I should do.

I have a large list of filtered data. After I filtered the data, I copied
and pasted it to a new worksheet. I would like Excel to randomly extract
every 50th record (or 100th record, just examples), and create a new list.

Is there a way to do this?
Do I have to copy and paste the data each time I filter and start the random
selection on a different worksheet?

Thanks for any suggestions!