title: How to keep the last row of a matching string in excel
body: <p>I want to remove all the rows except the last one for a matching userId "james.oconnor", i have a huge excel file and there are multiple rows of same "userId" with different "account" name. i want to keep only the last row having all the "account" name for a given userId - how can i do that?</p>
  
  <p>How can i turn my Excel file from <img src="https://i.stack.imgur.com/lK8ld.png" alt=""> to 
  <img src="https://i.stack.imgur.com/ieOvf.png" alt=""></p>
  
  <p>Many Thanks, Deepak</p>