title: Excel Find the first zero after a non zero within a range
body: <p>I have a range, that contains data which follows a distribution *typically starts at 0, then goes up, then down, and finally back to zero.
  I want to return the value of another column at the point that the data returns back to Zero  (in my case you can see that Cell B6 is the point at which this event occurs, and I want my cell C2 to return the value &quot;E&quot; from cell A6...</p>
  <p><a href="https://i.stack.imgur.com/J2HtP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/J2HtP.png" alt="enter image description here" /></a></p>
  <p>Currently, the best I can get to is the following:</p>
  <pre><code>=INDEX(A2:B8,FIND(0,
  TEXTJOIN(,,B2:B8),
  MATCH(AGGREGATE(4,4,B2:B8),B2:B8,0)) -1,1)
  </code></pre>
  <p>The problem comes in with the fact that there can be any number of zeros before the data appears.
  i.e. like this.  = Where I would still expect the highlighted match.</p>
  <p><a href="https://i.stack.imgur.com/fYsY0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fYsY0.png" alt="enter image description here" /></a></p>