title: How to get the newest value from a column with conditions
body: <p>I have a table in Excel which has the columns:</p>
  
  <ol>
  <li>Date</li>
  <li>Person Name</li>
  <li>Amount (£)</li>
  </ol>
  
  <p>The table is used to record when people pay me money. Typically, I can get more than one person paying me on the same day. Also, the same person will pay me on many days over the course of time.</p>
  
  <p>Records are added to the bottom of the table so the ordering will be on date but no further ordering on name or amount.</p>
  
  <p>Using formulas, is there a way I can retrieve the most recent amount for a specific person?</p>
  
  <p>If this is too complicated or not possible then I can settle for the following work around:
  Add a 4th column to the table called "Last". This will display TRUE if it is the last entry for a specific person, FALSE if it is not.</p>