Filtering out duplicates

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.

Please, always say your operate system and LibreOffice version.

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

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.

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.

Thnaks for your input! Solved it :slight_smile: