title: Find last non-zero cell's column reference in an UNORDERED range of values
body: <p>I have a range with numbers in a row in Excel, say:</p>
  
  <pre><code>          A  B  C  D  E  F  G  H  I  J  K  L
  Line 1 =&gt; 0  0  0  3  2  8  3  6  0  0  0  0
  </code></pre>
  
  <p>All cells are non-blank but some contain zeros and some contain numbers.  Also, the range cannot be ordered in either ascending or descending order.</p>
  
  <p>I need a formula (not VBA) that will return the column of the last non-zero value in the range (i.e. column 8 for cell H1 above).  I can get the actual value of cell H1 with this formula: </p>
  
  <pre><code> LOOKUP(2,1/(A1:A10&lt;&gt;0),A1:A10)  
  </code></pre>
  
  <p>but I cannot find a way to get the column number for that cell.</p>
  
  <p>Any ideas?</p>