Posted to microsoft.public.excel.worksheet.functions

fruitchunk fruitchunk is offline

external usenet poster

Posts: 35

How to generate random numbers from a range of cells?

I have a list of 25 differnt numbers in cells from A1 to A25
How can I randomly pick 5 numbers from the range A1:A25
I would like the 5 number to show up in cells C1 to G1

Thanks

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
Generate random numbers	cawhitaker	Excel Discussion (Misc queries)	3	September 27th 07 09:01 PM
Generate Random numbers from a pre-defined set	frankjh19701	Excel Worksheet Functions	0	January 11th 07 05:20 PM
Generate Random numbers from a pre-defined set	frankjh19701	Excel Worksheet Functions	0	January 11th 07 05:20 PM
How to generate a bunch of random numbers???	ddawg09	Excel Discussion (Misc queries)	6	March 13th 06 01:33 AM
generate random numbers	Jules	Excel Worksheet Functions	6	November 2nd 04 05:57 PM

All times are GMT +1. The time now is 12:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us