Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 4

Randomly Select Records

I need a way to randomly select 400 records from a worksheet containing
around 2000. Is there a formula or function that will do this?

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 to randomly select data in excel	random selection of data	Excel Worksheet Functions	4	October 4th 06 01:51 AM
Randomly select numbers from a range	Fred Smith	Excel Discussion (Misc queries)	15	October 3rd 06 02:01 AM
how to randomly select a name in a list and then the select the ne	[email protected]	Excel Worksheet Functions	1	September 20th 06 08:09 AM
randomly select numbers	jollycarrier	Excel Discussion (Misc queries)	2	August 18th 06 02:54 PM
randomly select value WITHOUT changing	Doyle Brunson	Excel Worksheet Functions	3	August 26th 05 12:52 AM

All times are GMT +1. The time now is 01:57 PM.

About Us

"It's about Microsoft Excel"