View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
realmfighter realmfighter is offline
external usenet poster
 
Posts: 1
Default Random Placement whilst fitting constraints

Hi,

Is it possible for excel in a selected set of cells, to place a letter (A,
B, C or D) in each of the cells "randomly" so that at the end there is a
total of 10 A's for example, 8B's, 9C's and 1D... overall?

Also, whenever anything is randomly generated in Excel, is there a way to
stop the values refreshing to new values everytime the user clicks something?

Any help would be most appreciated,

Thanks.