删除计算中的重复行？ [英] Delete duplicate rows in calc?

问题描述

我在openoffice calc中有一列有一组代码的列。例如：

  B1 
 B1 
 Br 
 Bh 
 Ht 
 C3 
 C3 
  

所以我想做的是删除所有的重复项我只剩下：

  Br 
 Bh 
 Ht 
  

任何帮助不胜感激。

干杯

解决方案

选择包含要过滤的数据的整个范围，然后单击菜单

数据>过滤器>标准过滤

和：

1. 使用始终为TRUE的条件，像field1 =不是空的




2. 点击更多按钮，选择删除重复，选择复制到一个空单元格的地址
   

来源

或者

对于Calc和Excel，快速而肮脏的解决方案将是

= COUNTIF（$ A：$ A; $ A1）

复制到列A中的每个条目。

结果为1的所有条目都可以过滤为新值。

COUNTIF的计算语法：

来源

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

解决方案

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

这篇关于删除计算中的重复行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！