title: Return second to last non empty cell in a range
body: <p><a href="https://i.stack.imgur.com/Kd2Dt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Kd2Dt.png" alt="enter image description here" /></a></p>
  <p>Can some one tell me how I can grab the second to last non empty cell in each roll
  =LOOKUP(2,1/(C13:M13&lt;&gt;&quot;&quot;),C13:M13) I used this formula =LOOKUP(2,1/(C13:M13&lt;&gt;&quot;&quot;),C13:M13) to capture the last non empty cell in a row but cant how to capture the one before it.</p>