Eliminate Rows Except the One with the Latest Dates

Hello All, First time poster here.

I have a 3 column excel sheet, that has a Person's Name, a Date, and a campaign event that they were involved in.

A person can exist multiple times, and I simply want to see the last Campaign that the person was involved in based on the date.

I have a massive database, and the only think I could think of was to use excel to help me find this information.

I have attached an example but without a formula that hopefully someone here could help provide.

Thanks!
Cteix

For Name, put this on E4 and ENTERED as ARRAY FORMULA

=IFERROR(INDEX($A$2:$A$35,SMALL(IF(FREQUENCY(IFERROR(MATCH(IF($A$2:$A$35<>"",$A$2:$A$35),$A$2:$A$35,0),""),ROW($A$2:$A$35)-ROW($A$2)+1),ROW($A$2:$A$35)-ROW($A$2)+1),ROWS($A$1:A1))),"")

For Date and Campaign Event, put this on F4 and copied down and cross as regular formular

=IFERROR(LOOKUP(2,1/($A$2:$A$35=$E4),B$2:B$35),"")