return sporadic numbers in a cell-area from a spesific number

  • Thread starter Thread starter farmer
  • Start date Start date
F

farmer

Hi - i have a job to do and i have 30 days (cells) and a number - eks 200 -
i want to spread out sporadic numbers in the 30 cells and the summary must
be 200.I know you proffesionals out there can tell me!
I`ll be pleased

Peter
 
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in. Use:

Tools > AddIns...
 
Ok now but the solution doesn work - the number i put in cell a 31 must be
ditributed randomly from cell A1 to A30 so the summary of A1 to A30 must be
like A31
 
Back
Top