title: How to get the cell reference of the second smallest value from a range of data
body: <p>I need to get the cell reference (specifically I only need the column number) of the second smallest value from a range of data.Complicated by the fact that the values in the range can be the same.
  eg.</p>
  
  <pre><code>A B C D E    
  1 5 2 1 8
  </code></pre>
  
  <p>Should return D as my column with the second smallest value.</p>
  
  <p>The current part of my code is as below:</p>
  
  <p>=SMALL('Sheet1'!C38:X38,2),'Sheet1'!C38:X38,0)</p>
  
  <p>However this leaves me with the problem that if the second smallest value is the same as the first only the first will be matched and returned.</p>
  
  <p>Is there any way to achieve this?</p>