Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to generate random number sets
Hi all. Trying to generate a set of 8 random numbers (1 - 45), say
A1:H1, without getting the same number twice in the same row. Then continue to A2:H2 and so on for say 60 rows. Have tried a few things but frustratingly unsuccessful. 'A favour for a Social Club group'. Thanks in advance for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to generate random number sets
See John McGimpsey's site for this.
http://www.mcgimpsey.com/excel/udfs/randint.html Gord Dibben MS Excel MVP On Wed, 5 Dec 2007 17:11:09 -0800 (PST), Kezza wrote: Hi all. Trying to generate a set of 8 random numbers (1 - 45), say A1:H1, without getting the same number twice in the same row. Then continue to A2:H2 and so on for say 60 rows. Have tried a few things but frustratingly unsuccessful. 'A favour for a Social Club group'. Thanks in advance for any help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to generate random number sets
See http://www.cpearson.com/excel/RandomNumbers.aspx
-- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Kezza" wrote in message ... Hi all. Trying to generate a set of 8 random numbers (1 - 45), say A1:H1, without getting the same number twice in the same row. Then continue to A2:H2 and so on for say 60 rows. Have tried a few things but frustratingly unsuccessful. 'A favour for a Social Club group'. Thanks in advance for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel, I want to generate a random number | Excel Discussion (Misc queries) | |||
How do I generate only one random number without it refreshing? | Excel Worksheet Functions | |||
How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
Generate Random Number Table | Excel Programming |