Randon Number Generators

pao · May 17th, 2002, 12:08 PM

I have five columns which I want to random generator number, which is easy but I do not want the same number generatored twice. I Need to check first column to see what number is and generator only number 2-5 and repeat this for each column Help

sen_edp · May 17th, 2002, 12:22 PM

Hi Pao

this might help

http://www.mrexcel.com/board/viewtop...c=8487&forum=2

Mark W. · May 17th, 2002, 12:30 PM

Also, take a look at my alternative recommendations at...

http://www.mrexcel.com/board/viewtop...c=8146&forum=2

Keep in mind that once the list is created a multi-column area can be populated from this list quite easily.

[ This Message was edited by: Mark W. on 2002-05-17 07:31 ]

Aladin Akyurek · May 17th, 2002, 12:34 PM

You might also consider using a UDF like MRAND from Longre's Morefunc add-in, dowloadable from:

http://longre.free.fr/english/index.html

May 17th, 2002, 12:22 PM	#2
sen_edp Join Date: Mar 2002 Location: Hellas Posts: 552	Hi Pao this might help http://www.mrexcel.com/board/viewtop...c=8487&forum=2 __________________ Best Regards Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 12:08 PM	#1
pao Join Date: Apr 2002 Posts: 13	I have five columns which I want to random generator number, which is easy but I do not want the same number generatored twice. I Need to check first column to see what number is and generator only number 2-5 and repeat this for each column Help

May 17th, 2002, 12:30 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,653	Also, take a look at my alternative recommendations at... http://www.mrexcel.com/board/viewtop...c=8146&forum=2 Keep in mind that once the list is created a multi-column area can be populated from this list quite easily. [ This Message was edited by: Mark W. on 2002-05-17 07:31 ]

May 17th, 2002, 12:34 PM	#4
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 40,611	You might also consider using a UDF like MRAND from Longre's Morefunc add-in, dowloadable from: http://longre.free.fr/english/index.html