title: Sorting duplicate submissions by date
body: <p>I have a Google form that deposits data to a google spreadsheet. All the data from the first form filled out will be deposited on row 1, then the next form filled out will be deposited on row 2, etc. A problem that I have been having is that sometimes people lose their link to edit their submitted form and they submit a whole new entry creating a duplicate row on google sheets with updated information. </p>
  
  <p>I am trying to make sheet2 that will filter out the duplicate entries but still keep the order that they first appeared. I have considered using <code>UNIQUE(range)</code> function however the problem is that the unique function takes the first time the name appears. What I want it to do is keep the position that the first name appears in but take the data of the latest time the name appears because that will have the updated information. I cannot figure out a way to do this on my own. Is there anyone who is more knowledgeable that can help?</p>
  
  <p>Below is an example of what I am hoping to achieve. The first time John appears is overwritten by the latest time it appears.</p>
  
  <p><a href="https://i.stack.imgur.com/AV2ma.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AV2ma.png" alt="enter image description here"></a></p>