Generate random numbers 1-100 without any repeats?
How do I generate random numbers from 1 to 100 without any repeated numbers?
Am using Excel 2003. |
Answer: Generate random numbers 1-100 without any repeats?
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:
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. |
All times are GMT +1. The time now is 08:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com