Ask Your Question

in Excel the data/remove duplicates where libreoffic

asked 2015-12-27 16:03:07 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Sorry I dont speak english... I'm Turkish...

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-12-30 09:58:37 +0200

pierre-yves samyn gravatar image


Sorry, my english is not good (french...) :)

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.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-12-27 16:03:07 +0200

Seen: 45 times

Last updated: Dec 30 '15