Talk:List of countries by intentional homicide rate/LibreOffice Calc instructions
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/Archive 4#Update table with latest rates and counts.