How could I get a random sample from an Excel Sheet

S

SAZFFXCTY

I am trying to create a sample from an excel report which contains about 3000
records. I would like to pick certain fields from this report and create a
separate file for about 10% of the records. Is there a way that I will be
able to create this kind of sample from the data.

Any help will be appreciated.

Thanks

Syed Zaman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
how to copy and paste value from one sheet to another 4
Macro for manipulating data 0
excel random sample with criterion 2
How do I clear a form? 0
How do I pull a random sample of people from a list in excel? 6
Alternate Row Select in Sheet 1 then Paste to Sheet 2 4
Random Sample 3

Top