View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kezza Kezza is offline
external usenet poster
 
Posts: 13
Default 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