title: Get start and end row number
body: <p>I have a worksheet that contains the following data:</p>
  
  <pre><code>  A   |B  
  --------
  1|DOG |1
  2|CAT |1
  3|CAT |2
  4|CAT |3
  5|FROG|1
  </code></pre>
  
  <p>where column A contains animal kinds and B contains some other data. I need a formula that will tell me which row number a particular animal kind starts and ends at. So for instance if I was looking for CAT I could get the starting row number as 2 and ending row number of 4.</p>
  
  <p>Has anyone got any ideas?</p>