title: find a row index of a number that occurred first
body: <p>I have <code>A</code> column that has values in random order like </p>
  
  <pre><code>       A column
             2
             3
             4
             2
             5
             6
             4
             3
             4
  </code></pre>
  
  <p>I want the row index of a particular number that occurred first. say if i say the number is 4 the value returned should be 3 </p>
  
  <p>I also want the row index of a particular number that occured last.say if i say the number is 3 then the value returned must be 8</p>
  
  <p>I was thinking <code>Vlookup</code> or <code>find</code> function must do the task but unable to put them in order.please help me with these </p>