title: Using Excel, How to split a number randomly to different cells but still total up to the original value?
body: <p>I'm trying to take the total number (the highlighted numbers) per each column  and split it randomly in the cells of the same column, till the end.<br />
  <a href="https://i.stack.imgur.com/P4teV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/P4teV.png" alt="enter image description here" /></a></p>
  <p>Every country will have a random number. All the random numbers for each country have to sum up to the total number.</p>
  <p>Pageviews nr &gt; Impressions nr &gt; Clicks nr</p>
  <p>C &gt; D &gt; E</p>
  <p>The number in column C has to be bigger than D.
  The number in column D has to be bigger than E.</p>