title: Count rows between non-empty cells
body: <p>Hi there i have a similar question to the question posed at</p>
  
  <p><a href="https://stackoverflow.com/questions/3475300/move-from-one-cell-to-another-and-count-the-number-of-rows-in-between-two-data">Move from one cell to another and count the number of rows in between two data</a></p>
  
  <p>In my example i would like count the number of rows between non-empty cells (including the original data line itself) in column A and put the count in Column B</p>
  
  <p>My data starts at A1 and moves down with blanks in cells until the the next data row.</p>
  
  <p>Example:</p>
  
  <pre><code>A1 1        B1 3
  A2          B2 4
  A3          B3 2
  A4 2        B4 3
  A5  
  A6  
  A7 
  A8 3  
  A9  
  A10 4
  A11 
  A12 
  </code></pre>
  
  <p>I tried to make mods to the original solution posted but i cant seem to get the count for the last row. </p>
  
  <p>Any assistance would be very much appreciated.</p>