title: Generate array of bin sizes in Excel
body: <p>The <a href="http://msdn.microsoft.com/en-us/library/ff840100.aspx" rel="nofollow">FREQUENCY</a> function in Microsoft Excel is useful for generating histograms. The first parameter is an array of data values (E.g. A1:A100). The second one is an array of bin sizes. I want to <em>generate</em> this array from three parameters:</p>
  
  <ul>
  <li>Minimum data value: MIN(A1:A100)</li>
  <li>Maximum data value: MAX(A1:A100)</li>
  <li>Bin size: constant</li>
  </ul>
  
  <p>That is, a formula/function should return the list of wanted values instead of manually putting them in cells.</p>
  
  <p>E.g. Consider a minimum value of 10, a maximum value of 100 and a bin size of 20. This would yield an array of the follow bin sizes: 10, 30, 50, 70, 90</p>
  
  <p>How can I accomplish this? Thanks.</p>