Remember Me?

#1
September 7th 06, 03:21 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 1
I want random numbers generated without repeating numbers

In my worksheet in column CC in C1:C20 I want Excel to ganerate 20 random
numbers between 1 and 80 without repeating the same numbers.
At present I have the following formula entered and it works, but after I
click F9 some repeated numbers are generated.

=INT(RAND()*(80-1)+1)

How can I change the formula or replace it?
Ragards to all supporters.
John.

#2
September 7th 06, 04:03 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 301
I want random numbers generated without repeating numbers

put the #s 1-80 in a column (D180) and put =RAND() next to it. Sort D1:E80
by column E. The top 20 values in D (D120) are what you want.

"Johncobb" <[email protected] wrote in message news:[email protected]..
In my worksheet in column CC in C1:C20 I want Excel to ganerate 20 random
numbers between 1 and 80 without repeating the same numbers.
At present I have the following formula entered and it works, but after I
click F9 some repeated numbers are generated.

=INT(RAND()*(80-1)+1)

How can I change the formula or replace it?
Ragards to all supporters.
John.

#3
September 7th 06, 04:52 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22,909
I want random numbers generated without repeating numbers

Couple of methods of creating lists of non-repeating random numbers at John
McGimpsey's site.

http://www.mcgimpsey.com/excel/udfs/randint.html

Gord Dibben MS Excel MVP

On Thu, 07 Sep 2006 14:21:27 GMT, "Johncobb" <[email protected] wrote:

In my worksheet in column CC in C1:C20 I want Excel to ganerate 20 random
numbers between 1 and 80 without repeating the same numbers.
At present I have the following formula entered and it works, but after I
click F9 some repeated numbers are generated.

=INT(RAND()*(80-1)+1)

How can I change the formula or replace it?
Ragards to all supporters.
John.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Smeeg Excel Worksheet Functions 8 March 5th 06 01:30 AM random number generator Excel Worksheet Functions 3 February 28th 06 06:35 PM Stew Excel Worksheet Functions 2 July 11th 05 07:17 PM darebo Excel Discussion (Misc queries) 2 December 6th 04 05:01 PM Jules Excel Worksheet Functions 6 November 2nd 04 05:57 PM

All times are GMT +1. The time now is 11:35 AM.