在Excel中计数重复 [英] Counting duplicates in Excel

问题描述

我有一个包含重复的邮政编码的列表。我想了解每个邮政编码的实例数量。

例如我想这样：

  GL15 
 GL15 
 GL15 
 GL16 
 GL17 
 GL17 
 GL17 
  

...成为这个：

  GL15 3 
 GL15 3 
 GL15 3 
 GL16 1 
 GL17 2 
 GL17 2 
  

理想情况是：

  GL15 3 
 GL16 1 
 GL17 3 
  

谢谢！

解决方案

不知道是否完全可以做你理想的模式。但是我找到了一种方式来做第一种方式：CountIF

  + ------- + ----- -------------- + 
 | A | B | 
 + ------- + ------------------- + 
 | GL15 | = COUNTIF（A：A，A1）| 
 + ------- + ------------------- + 
 | GL15 | = COUNTIF（A：A，A2）| 
 + ------- + ------------------- + 
 | GL15 | = COUNTIF（A：A，A3）| 
 + ------- + ------------------- + 
 | GL16 | = COUNTIF（A：A，A4）| 
 + ------- + ------------------- + 
 | GL17 | = COUNTIF（A：A，A5）| 
 + ------- + ------------------- + 
 | GL17 | = COUNTIF（A：A，A6）| 
 + ------- + ------------------- + 
  

I have a list of postcodes that includes duplicates. I would like to find out how many instances of each postcode there are.

For example I would like this:

GL15
GL15
GL15
GL16
GL17
GL17
GL17

...to become this:

GL15 3
GL15 3
GL15 3
GL16 1
GL17 2
GL17 2

...or ideally this:

GL15 3
GL16 1
GL17 3

Thanks!

解决方案

I don't know if it's entirely possible to do your ideal pattern. But I found a way to do your first way: CountIF

+-------+-------------------+
|   A   |         B         |
+-------+-------------------+
| GL15  | =COUNTIF(A:A, A1) |
+-------+-------------------+
| GL15  | =COUNTIF(A:A, A2) |
+-------+-------------------+
| GL15  | =COUNTIF(A:A, A3) |
+-------+-------------------+
| GL16  | =COUNTIF(A:A, A4) |
+-------+-------------------+
| GL17  | =COUNTIF(A:A, A5) |
+-------+-------------------+
| GL17  | =COUNTIF(A:A, A6) |
+-------+-------------------+

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