title: Make array of numbers in one cell in Excel
body: <p>Is it possible to store some numbers in one cell (as an array)?
  Please see below:</p>
  <p>cell A1: <code>4,4,3,4,1,3,3,4</code></p>
  <p>cell A2: <code>5</code>  (5th element of array)</p>
  <p>cell A3: <code>546254</code> (constant for this month)</p>
  <p>cell A4: <code>=(MAX(A1)-INDEX(CHOOSE({1,2,3,4,5,6,7,8},A1),1,A2))  *  (A3/SUM(A1))</code> (here 63029)</p>
  <p>The formula of cell A4 causes error. Only way to solve it changing it as below:</p>
  <p>cell A4: <code>=(MAX(4,4,3,4,1,3,3,4)-INDEX(CHOOSE({1,2,3,4,5,6,7,8},4,4,3,4,1,3,3,4),1,A2))  *  (A3/SUM(4,4,3,4,1,3,3,4))</code></p>
  <p>So, I should write whole array in formula. I don't want to use VBA and Named Ranges.</p>