Calculating and re-calculation a matrix of 100 numbers in Excel

  • Thread starter Thread starter SAND1100
  • Start date Start date
S

SAND1100

I am using Excel to calculate a matrix of 100 random numbers and sum the total
place the result in a cell, generate new random numbers for the matrix and sum
those place the result in a second cell, and so on.

I am using a Do while loop however -how do I get each calculation of the sum in
a cell to be independent from previous calculations in other cells? Right now
my program just recalculates the matrix and I get the same answer for each
cell.

Thanks,

SA
 
What formulas do you use? Both for the matrix and the sum?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top