Posted to microsoft.public.excel.programming

terry freedman terry freedman is offline

external usenet poster

Posts: 16

selecting random records

Hi

does anyone know how to do this please?

From a spreadsheet consisting of about 800 rows (records) select a
random sample of records(about 50) and also create a data set by
selecting every 10th record.

TIA

Terry
==
Terry Freedman
www.ictineducation.org

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
selecting records	Roy Gudgeon[_2_]	Excel Discussion (Misc queries)	2	March 9th 10 10:30 AM
Selecting Random Records From an Excel Sreadsheet	Trevor Aiston[_2_]	Excel Worksheet Functions	3	June 29th 09 11:20 AM
the formula for random selecting	Inquiring mind	Excel Discussion (Misc queries)	2	March 19th 09 02:33 PM
Selecting Random Data	myssieh	Excel Worksheet Functions	5	February 13th 08 05:09 PM
Selecting Random Data	Willie	Excel Worksheet Functions	2	August 18th 05 06:26 PM

All times are GMT +1. The time now is 11:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us