title: Find last occurrence of specific value in a row
body: <p>I have a table that keeps scores from fantasy football league. The lowest scoring week is not included in the total. </p>
  
  <p>I'm able to find the lowest score using the <code>=min function [=min(B2:R2)]</code></p>
  
  <p>I can find the first instance using the <code>=match function. [=MATCH(S2,B2:R2,0)]</code></p>
  
  <p>However I would like a formula that returns the latest occurrence of the lowest scoring week.</p>
  
  <p>For example Portia lowest score is 8 the first occurrence is week 4 but I would like it to return the latest occurrence which is week 11 </p>
  
  <p><a href="https://i.stack.imgur.com/NRPbN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NRPbN.jpg" alt="enter image description here"></a></p>