Delete duplicate rows in calc?

duplicate-removal openoffice-calc
user2120088 picture user2120088 · Mar 19, 2014 · Viewed 6.9k times · Source

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

Answer

Matt picture Matt · Mar 19, 2014

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

Related questions

C# LINQ find duplicates in List

Using LINQ, from a List<int>, how can I retrieve a list that contains entries repeated more than once and their values?

Read More
Delete duplicate records from a SQL table without a primary key

I have the below table with the below records in it create table employee ( EmpId number, EmpName varchar2(10), EmpSSN varchar2(11) ); insert into employee values(1, 'Jack', '555-55-5555'); insert into employee values (2, 'Joe', '555-56-5555'); insert into …

Read More
Eliminating duplicate values based on only one column of the table

My query: SELECT sites.siteName, sites.siteIP, history.date FROM sites INNER JOIN history ON sites.siteName = history.siteName ORDER BY siteName,date First part of the output: How can I remove the duplicates in siteName column? I want to …

Read More