Ask Your Question

Filtering out duplicates

asked 2019-12-10 14:54:12 +0200

Curiously gravatar image

C:\fakepath\kõik artiklid.xlsx

I need to order this table by dublicates so that all duplicates are on top and then come unique values. I manage to mark duplicates red but i can´t figure out how to sort them so that all duplicates are together.

edit retag flag offensive close merge delete


Please, always say your operate system and LibreOffice version.

mauricio gravatar imagemauricio ( 2019-12-10 18:29:35 +0200 )edit

What do you like to achieve, have the list without duplicates, have only those values with duplicates?

m.a.riosv gravatar imagem.a.riosv ( 2019-12-10 19:51:20 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-12-10 18:28:36 +0200

gregors15 gravatar image

Hi, can you add another column (B) and use the function COUNTIF, something like =COUNTIF($A$1:$A$44327,A1), then sort on the new columnB (Descending)/columnA. Let us know if it helps.

edit flag offensive delete link more


Not sure it is what is wanted, maybe =COUNTIF(A1:$A$44327,A1), so counts how many duplicates the value have down, allowing after inverse order on this column, to have the duplicates all above.

m.a.riosv gravatar imagem.a.riosv ( 2019-12-10 19:51:23 +0200 )edit

Thnaks for your input! Solved it :)

Curiously gravatar imageCuriously ( 2019-12-11 10:08:50 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-12-10 14:54:12 +0200

Seen: 303 times

Last updated: Dec 10 '19