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

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

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