See: How can I see only the latest year for each country in a spreadsheet? - for Calc.

It needs to be rewritten, simplified, and copied here.

For another method see: User:Timeshifter/Sandbox223 and Talk:List of countries by intentional homicide rate#Update table with latest rates and counts.