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.
|