title: Dynamic Range Between Blank Rows in Excel
body: <p>I've got a table that looks like this: </p>
  
  <pre><code>Date       MaturityDate ZeroRate
  
  5-May-15    5-May-15    1
  5-May-15    6-May-15    0.0069999329
  5-May-15    5-Jun-15    0.008996562
  5-May-15    6-Jul-15    0.008993128
  5-May-15    5-Aug-15    0.006744264
  5-May-15    5-Nov-15    0.006912941
  
  5-May-15    5-May-16    1
  5-May-15    5-May-17    0.006910929
  5-May-15    6-Nov-17    0.007017292
  5-May-15    7-May-18    0.00712202
  5-May-15    5-Nov-18    0.007835916
  5-May-15    6-May-19    0.008551509
  5-May-15    5-Nov-19    0.009734602
  5-May-15    5-May-20    0.010916848
  
  5-May-15    5-Nov-20    1
  5-May-15    5-May-21    0.012632521
  5-May-15    5-Nov-21    0.013504069
  5-May-15    5-May-22    0.014366506
  5-May-15    7-Nov-22    0.014935518
  5-May-15    5-May-23    0.0154865
  5-May-15    6-Nov-23    0.016059181
  5-May-15    6-May-24    0.016626256
  </code></pre>
  
  <p>It's split up into evenly spaced blocks with a row between each "1". </p>
  
  <p>I've got a function of the form TestFunction(reference cell, Table Range). I want the "table range" part to refer to the cells in between the blank rows. Is there a way that I can drag down the TestFunction and have it automatically select as a range the blocks between blank rows?</p>
  
  <p>I tried coding something like</p>
  
  <pre><code>D2: =IFERROR(IF(ISBLANK(C2),TestFunction(B2, INDEX(A:A,LOOKUP(2,1/ISBLANK(C$2:C2),ROW(C$2:C2))):C2),""),"") 
  </code></pre>
  
  <p>but this is awfully convoluted and doesn't work. </p>
  
  <p>Any suggestions? Thanks. </p>