Posted to microsoft.public.excel.worksheet.functions

SAZFFXCTY

external usenet poster

Posts: 1

How could I get a random sample from an Excel Sheet

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How could I get a random sample from an Excel Sheet	Gary''s Student	Excel Worksheet Functions	0	March 8th 07 07:36 PM
random sample	skimpw	Excel Worksheet Functions	0	August 15th 06 01:15 AM
excel random sample with criterion	gilgamesh2006	Excel Worksheet Functions	2	May 2nd 06 12:54 AM
Is it possible to do a random sample of non-numeric data in Excel?	Terri G	Excel Discussion (Misc queries)	4	December 15th 05 05:44 PM
How do I pull a random sample of people from a list in excel?	PM	Excel Worksheet Functions	6	November 29th 05 04:41 AM

All times are GMT +1. The time now is 11:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us