View Single Post
  #1  
Old 07-09-2009, 10:38 PM
nguyennb nguyennb is offline
Registered User
 
Join Date: 10 Apr 2009
Location: VietNam
MS Office Version:Excel 2003
Posts: 11
nguyennb is becoming part of the community
Create a random array contain a fixed number

I want to create an array contain random 4 number, but one of them is a fixed number.
For example, fixed number is 2, arrays are 1,2,5,9; 2,6,7,8; 2,5,9,15..
.The numbers are between 1 and 100.
How can I do it ?
Reply With Quote