Delete duplicate data in Column I leaving just one unique row

[mingandmong]

Hi
I'm using excel 2016

i have a spreadsheet with 56,000 rows and in column I have i have a set of data that is duplicated
i would like to delete the duplicates... however i need to retain the very last row of the duplicate as an example i have highlighted in red below ( the data is just a mock setup)
Many Thanks in advance

ie

Column I

John
John
John
John
Peter
Peter
Peter
Frank
Frank

 

[mingandmong]

Hi Gerald

It did not give me a true &false the first time.. i have retried and yes i dont need the if statement