title: Counting Non-Blank Cells Under a Given Heading
body: <p>I have a large list of similar reports, and these reports each have a "Name:" cell in the first column and a set of objects listed, say, "Objects" in the same column.  After two instances of the string "Name:" and some other rows in between (both blank and filled) we arrive at the "Objects" string.  After each instance of the word "Objects" there is a list of numbers counting off the total number of objects.  There are an arbitrary number of objects in each list, but the fact that they always come after the title "Objects" is constant.  Is there an easy way to have Excel search through each report and place the name found under "Name:" in some cell and the count of all non-blank cells after the word "Objects" beside it?  Since the list of objects is unbroken the first blank cell could trigger the count to stop and move onto the next list while a large number of blank cells (say more than 300) could trigger the program to declare that there are no more entries to be pulled out and stop).</p>
  
  <p><strong>Example</strong></p>
  
  <pre><code>    A              B           C
  
      Name:      John Smith
  
  
      Date:       March 5th
  
      Name:       John Smith
  
     Objects
      List 
        1            Filler1     Something1
        2            Filler2     Something2
        3            Filler3     Something3
        4            Filler4     Something4
        5            Filler5     Something5
        6            Filler6     Something6
  
      Name:      Jane Doe
  
  
      Date:       March 8th
  
      Name:       Jane Doe
  
     Objects
      List 
        1            Filler1     Something1
        2            Filler2     Something2
        3            Filler3     Something3
        4            Filler4     Something4
  </code></pre>
  
  <p>The result would then be something like:</p>
  
  <pre><code>    John Smith         6
      Jane Doe           4
  </code></pre>