title: excel/vba - find fist and last occurrence of a particular value in a column
body: <p>So if I have a column such as:</p>
  
  <pre><code>    A1
  1   Apple
  2   Apple
  3   Apple
  4   Oj
  5   Oj
  6   Oj
  7   Oj
  8   Pear
  9   Pear
  </code></pre>
  
  <p>How could I return the values 1 &amp; 3 for Apple, 4 &amp; 7 for OJ, etc?</p>