title: How to run a calculation with random numbers and keep the number set that returns the lowest delta?
body: <p>I am trying to wrap my head around how to run a series of calculations using random numbers and keep the number set that returns the lowest delta from the original data set. </p>
  
  <p>I am trying to recreate data by using random number constraints and want to cycle through the random numbers for a set number of cycles and then have excel  repopulate the data with the random sample set that had the lowest delta from the original data set.</p>
  
  <p>I am calulating the random data set using the formula AVERAGE of the original data + RANDBETWEEN(-STDEV, STDEV). The delta is the difference between the original data and the random data set. </p>
  
  <p>Sum Delta is the sum of the deltas.</p>
  
  <p>Its not that I am looking for each individual random data to match the original data, but the total sum to match the original data.</p>
  
  <p>The first run looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/z3p72.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/z3p72.png" alt="Example"></a></p>
  
  <p>So when the random number is recalculated it looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/GMDEx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GMDEx.png" alt="enter image description here"></a></p>