title: How to get max date from one column and match with other column in Excel?
body: <p>I have excel sheet data like below </p>
  
  <pre><code>CustomerNo LoginDate
  101        25/05/2012
  101        10/05/2012
  101        20/05/2012
  101        10/04/2012
  102        21/05/2012
  102        12/04/2012
  103        20/05/2012
  104        08/04/2012
  </code></pre>
  
  <p>I want to get last login date match with customer number and result like below.</p>
  
  <pre><code>101   25/05/2012
  102   21/05/2012
  103   20/05/2012
  104   08/04/2012
  </code></pre>