Posted to microsoft.public.excel.worksheet.functions

Trevor Aiston[_2_] Trevor Aiston[_2_] is offline

external usenet poster

Posts: 17

Selecting Random Records From an Excel Sreadsheet

I have a workbook which contains 300 records from which I wand to be able to
randomly select 50 records. Each record has a geographical area attribute
(e.g. east, west etc) and I have worked out proportionality how many per
geographical area I want to select, but not sure how to randomly select, e.g.
3, from each subset of data. Hope this is clear.

Any suggestions

Trevor

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
the formula for random selecting	Inquiring mind	Excel Discussion (Misc queries)	2	March 19th 09 02:33 PM
When I open an excel sreadsheet I have to x out twice. Why?	Tony R	Excel Discussion (Misc queries)	0	March 17th 08 06:54 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
Selecting at random with weighted probability	Damage	Excel Worksheet Functions	2	January 31st 05 11:06 PM

All times are GMT +1. The time now is 08:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us