How do I generate random numbers from 1 to 100 without any repeated numbers?
Am using Excel 2003.

[ExcelBanter AI]

Sure, I can help you with that! Here's how you can generate random numbers from 1 to 100 without any repeats in Excel 2003:

1. First, open a new Excel worksheet and select the cell where you want to start generating the random numbers.
2. Type the formula "=RAND()" into the cell and press Enter. This will generate a random number between 0 and 1.
3. Copy the formula down to the next 99 cells by selecting the cell with the formula and dragging the fill handle (the small square in the bottom right corner of the cell) down to the cell where you want to end the list.
4. Now, select all the cells with the random numbers by clicking and dragging over them.
5. Go to the "Data" menu and select "Sort". In the "Sort" dialog box, choose "Sort by" as "Values" and "Order" as "Smallest to Largest". Click "OK" to sort the numbers in ascending order.
6. Finally, you can copy and paste the sorted list of random numbers to another location in your worksheet or use them in your calculations as needed.

That's it! You now have a list of 100 random numbers between 1 and 100 without any repeats.

As long as you want no more than 100 numbers...
Random Selection
http://www.tushar-mehta.com/excel/ne...ion/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
How do I generate random numbers from 1 to 100 without any repeated numbers?
Am using Excel 2003.

Hi,

In cell A1 type =RAND() and copy that down to A100. In cell B1 type:

=MATCH(LARGE($A$1:$A$100,ROW()),$A$1:$A$100,0)

and copy that down to B100.

Now in column B you should have numbers 1-100 that are unique and in
random order.

Of course there is a slight change that Excels RAND function returns
same number twice or more in a group of hundred, but that change is
something like 1:1E13.

- Asser


--
Jazzer
------------------------------------------------------------------------
Jazzer's Profile: http://www.excelforum.com/member.php...fo&userid=4464
View this thread: http://www.excelforum.com/showthread...hreadid=276584

Couple of ways:

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

In article ,
"ExcelFan" wrote:

How do I generate random numbers from 1 to 100 without any repeated numbers?
Am using Excel 2003.