title: Excel: Find last value in an array
body: <p>I have a dataset with </p>
  
  <pre><code>&gt; A b c d...AA,BB
  &gt;1,2,3,4 
  &gt; apple apple apple
  &gt; orange pear pear apple pear
  &gt; grapefruit,grape, grape,grape
  </code></pre>
  
  <p>Is there a way to find the final occurence of a particular fruit in the array automatically via formula in Excel?</p>