title: Excel: Lowest value in column A while Column B is not blank
body: <p>In Column B I have the word &quot;setup&quot; which appears in sporadic blocks going down the column.</p>
  <p>The blocks could be 2 rows high or 30 rows high.</p>
  <p>In Column A I have a number.</p>
  <p>In Column C I would like to pick out the lowest number from Column A while Column B is not empty and place it at the top of each block.</p>
  <p><a href="https://i.stack.imgur.com/vaYZX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vaYZX.png" alt="enter image description here" /></a></p>
  <p>Can anybody help please?</p>