In Excel the data/remove duplicates where libreoffic

Sorry I dont speak english… I’m Turkish…


Sorry, my english is not good (french…) :slight_smile:

DataFilterStandard FilterOptions allows to filter and eliminate duplicates.
But beware this is to exclude duplicate rows: it excludes only rows for which all columns are duplicated.

To filter rows from one column simply select only this column.

You can also create a “test” column with the COUNTIF function in a formula. See DoublonsCorr.ods.

This short video (in French) explains the various possibilities.