title: Reverse a 1d array output from a function (or get the last value), without VBA?
body: <p>Suppose I have a UDF <code>MyFunc()</code> which is too costly to call more than once, <code>MyFunc()</code> returns an array.  By default, if applied to a single cell then the first value in the array is used.  I want the last value of the array.  </p>
  
  <p>So, is it possible to:</p>
  
  <ul>
  <li><p>(a) reverse the array so that the last value is used, or</p></li>
  <li><p>(b) just grab the last value directly?</p></li>
  </ul>