title: How to get the latest date with same ID in Excel
body: <p>I want to Get the Record with the most recent date as same ID's have different dates. Need to pick the BOLD values. Below is the sample data, As original data consist of 10000 records.</p>
  
  <ul>
  <li>ID  Date</li>
  <li><strong>5   25/02/2014</strong>       </li>
  <li>5 7/02/2014</li>
  <li>5 6/12/2013</li>
  <li>5 25/11/2013</li>
  <li>5 4/11/2013</li>
  <li><strong>3   5/05/2013</strong>           </li>
  <li>3 19/02/2013</li>
  <li>3 12/11/2012       </li>
  <li><strong>1   7/03/2013</strong></li>
  <li><strong>2   24/09/2012</strong></li>
  <li>2 7/09/2012</li>
  <li><strong>4   6/12/2013</strong></li>
  <li>4 19/04/2013</li>
  <li>4 31/03/2013</li>
  <li>4 26/08/2012</li>
  </ul>