RANDOM NUMBERA

abz2max · Apr 23rd, 2002, 05:50 AM

HOW CAN I CREATE A LIST OF RANDOM NUMBERS WITHOUT ANY OF THEM REPEATING THEMSELVES.

Chris Davison · Apr 23rd, 2002, 06:06 AM

there's quite a few good examples already on this board.... try a quick search on "=RAND" or "=RANDBETWEEN" you'll probably find exactly what you need...... if not, wait a while and there'll be a few suggestions, I'm sure of it !

Mark W. · Apr 23rd, 2002, 07:40 AM

Quote:

On 2002-04-23 04:50, abz2max wrote:
HOW CAN I CREATE A LIST OF RANDOM NUMBERS WITHOUT ANY OF THEM REPEATING THEMSELVES.

1. Enter =RAND() in cell A1 and fill down as many rows as numbers needed.
2. Enter =RANK(A1,A:A) into cell B1 and fill down to used last row in column A.

[ This Message was edited by: Mark W. on 2002-04-23 06:54 ]

Apr 23rd, 2002, 06:06 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	there's quite a few good examples already on this board.... try a quick search on "=RAND" or "=RANDBETWEEN" you'll probably find exactly what you need...... if not, wait a while and there'll be a few suggestions, I'm sure of it ! __________________ :: Pharma Z - Family drugstore ::

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

Apr 23rd, 2002, 05:50 AM	#1
abz2max New Member Join Date: Apr 2002 Posts: 19	HOW CAN I CREATE A LIST OF RANDOM NUMBERS WITHOUT ANY OF THEM REPEATING THEMSELVES.