title: Excel formula to get last entry in a row
body: <p>I have a sheet where each row begins with a string identifier, followed by a series of values for each week since the sheet was created:</p>
  
  <pre><code>XXX    15    20    25
  YYY    11    15    19
  ZZZ    18    22    22
  </code></pre>
  
  <p>On another sheet I would like to have some of the string identifiers from the first page (not all), and only the latest value for that item:</p>
  
  <pre><code>XXX    25
  ZZZ    22
  </code></pre>
  
  <p>I actually want multiple sheets of the second kind, with each string id possible appearing on more than one sheet.</p>
  
  <p>I can't use VBA as this has to be viewed (and values added and altered) on my Windows Phone 7 (I do not believe the mobile version of excel supports VBA, but correct me if I'm wrong). Is there a formula that's able to do this?</p>