Make Office Better
Top tips for the best office programs
LIBREOFFICE CALC
Remove duplicate entries from spreadsheets
In earlier versions of LibreOffice Calc, removing duplicate entries from columns and rows in a spreadsheet meant using the sorting or filtering tools, or typing complex formulas. Version 25.2, released in February, makes this much easier.
Select the cells containing the data, then click Data at the top followed by Duplicates. In the window that opens, next to Compare, select Rows ( 1 in our screenshot below) if you want to check whether any data in your rows is duplicated (as is the case in our example 2 ), or Columns to check in those. Tick ‘Data contains row headers’ if this applies, and ‘Compare by: All’ to compare all the rows/columns 3 .