Ask Your Question
0

Filtering out duplicates

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

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

Comments

Please, always say your operate system and LibreOffice version.

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

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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

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

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

Comments

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 +0100 )edit

Thnaks for your input! Solved it :)

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

Question Tools

1 follower

Stats

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

Seen: 247 times

Last updated: Dec 10 '19