View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hasinque
 
Posts: n/a
Default Create 5 unique value between 1 and 14?


Hi, I am done. After 4 hours I cannot find an easy method to create 1000
rows with each row having 5 values. These value are unique and between 1
and 14.

So it looks like this
3 4 6 10 12
11 12 1 2 5
.........

please, there must be an easy solution. dont hate me for the lack of
brain.

thanks in advance.


--
hasinque
------------------------------------------------------------------------
hasinque's Profile: http://www.excelforum.com/member.php...o&userid=35387
View this thread: http://www.excelforum.com/showthread...hreadid=551625