title: Find highest number within a dynamic range R
body: <p>I have a column in my chronologically-sorted <code>df</code> which indicates the observation (or row number) in the <code>df</code> when a certain trigger condition is met in the future, e.g. <code>df$condition_met &lt;- c(NA, NA, 61, NA, ...)</code> - i.e. the third row of my <code>df</code> is the first occurrence where the condition is met, and it is met in row 61. (I'm not sure you even need this context!)</p>
  
  <p>I want to find the maximum value in a different column (<code>df$high</code>) between the row after the row number I am in (<code>3+1</code> in this example) and the row before the condition being met (<code>60</code> in this example.)</p>
  
  <p>Any help much appreciated!</p>