CODEWITHSUNDEEP
duplicatesopenoffice-calc
user2120088
user2120088

Reputation: 79

Delete duplicate rows in calc?

I have a column in openoffice calc with a set of codes. For example:

B1
B1
Br
Bh
Ht
C3
C3

So what I would like to do is delete all the duplicates so I am left with just:

Br
Bh
Ht

Any help much appreciated.

Cheers

Upvotes: 6

Views: 7931

Answers (1)

Matt
Matt

Reputation: 15061

Select the entire range containing data to filter, then click on the menu

Data > Filter > Standard Filter

and:

  1. Use a condition that is always TRUE, like field1 = Not empty

  2. Click on the button more, select Remove Duplicate, select Copy to and put the address of an empty cell The whole range (without duplicate) will be analyzed and copied at that new address.

source

Or

For both Calc and Excel the quick and dirty solution would be

=COUNTIF($A:$A;$A1)
copied down for every entry in Column A.

All entries where the result is 1 can be filtered as new values.

Calc syntax for COUNTIF:

Source

Upvotes: 8

Related Questions