bala_vb

Senior Member

Location: Hyderabad

Posts: 237

Quote:

Originally Posted by pat67

Hey is there a way to generate random numbers like you would for a
draft. In other words, i have numbers 1 through 10 and generate a
random order for those?

in excel 2003:
=CEILING(RAND()*10,1)

in excel 2007 using RANDBETWEEN function
example: randbetween(1,10)

all the best

__________________
Thanks
Bala

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Random number Generator	RayT	New Users to Excel	14	January 15th 08 11:16 PM
Random Number generator	Neil M	Excel Worksheet Functions	2	February 1st 06 06:00 PM
Random Number Generator	STEVEB	Excel Worksheet Functions	7	July 25th 05 11:41 PM
Random Number Generator	Pascale	Excel Worksheet Functions	3	July 9th 05 12:37 AM
Random number generator	Philippe L. Balmanno	Excel Worksheet Functions	4	December 17th 04 07:42 AM

All times are GMT +1. The time now is 03:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us