Filtering out duplicates

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

Curiously
1 ●1 ●1 ●1

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 ( 2019-12-10 18:29:35 +0100 )edit

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

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

gregors15
191 ●3 ●5

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

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 ( 2019-12-10 19:51:23 +0100 )edit

Thnaks for your input! Solved it :)

Curiously ( 2019-12-11 10:08:50 +0100 )edit

add a comment

Question Tools

1 follower

Stats

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

Seen: 272 times

Last updated: Dec 10 '19

Filtering out duplicates edit

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

Filtering out duplicates