title: How do I delete ROWS based on some calculations on column value in EXCEL
body: <p>Please help me in below scenario, </p>
  
  <p>I have some data in excel and I want to delete rows based on ID and higher Timestamp( I want to keep only latest records for each ID). </p>
  
  <p><a href="https://i.stack.imgur.com/eLGxm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eLGxm.png" alt="This is sample data "></a></p>
  
  <p>For each ID I want to keep only the first row as my data is sorted in descending order and I want to delete all other rows for that particular ID. For Example, </p>
  
  <p>ID = 6000001, I only want to keep first row which has timestamp <strong>2019-12-19</strong>  and 2nd row I want to delete. Same way only high timestamp row I want to keep for all ID's. </p>
  
  <p>Much Thanks in Advance. </p>