View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
IPMS IPMS is offline
external usenet poster
 
Posts: 1
Default Select a random sample

How do I randomly select a sample of data (rows), from a given set of large
data in the Excel program?
Example: I have 100 rows of information. I need to randomly select 10% or 10
of the rows from the 100 rowed items and place that information on either
another worksheet or another blank area of the existing worksheet.