为什么对电子邮件列进行排序时,重复的电子邮件不会显示在彼此下方?

huangapple go评论72阅读模式
英文:

Why does sorting a column of emails not show duplicates under each other?

问题

我正在尝试在Google表格列中标记重复的电子邮件地址。我不能使用“删除重复项”功能,因为我需要标记它们,而不是删除它们。

当我使用条件格式设置来突出显示重复项,然后对列进行排序时,我注意到重复的电子邮件不会出现在彼此下面。

我使用了这个自定义公式的条件格式:“=COUNTIF($A$2:$A$10, A2)>=2”

但我有两个问题:

  1. 当我将电子邮件列从A到Z排序时,一些突出显示的值(重复项)不会出现在彼此下面。我不明白为什么会这样,因为只应用了一次排序。

  2. 这个公式只突出显示了重复的值,而不是“原始值”(被复制的值)。

例如,如果我的列包含“email@email.com”和“email@email.com”,只会突出显示其中一个。我需要两者都突出显示。

我将包含一个截图以进一步说明:

如您所见,只有一个重复项被突出显示,再加上一个单一值被突出显示,这让我认为“8293227@gmail.com”的重复项可能在其他地方,但我找不到它。

示例截图在这里

提前感谢您的帮助! 🙏

英文:

I'm trying to flag duplicate email addresses in a Google Sheet column. I can't use the "remove duplicate" feature cause I need to flag them, not delete them.

When I use conditional formatting to highlight duplicates and then sort the column, I notice that duplicate emails do not appear under each other.

I used conditional formatting with this custom formula "=COUNTIF($A$2:$A$10, A2)>=2"

But I have two issues with it:

  1. When I sort the column of emails from A to Z, some highlighted values (duplicates), do not appear under each other. I don't understand how this is possible since only 1 sort is being applied.

  2. The formula only highlights the duplicated value, not the "original value" (that is being duplicated)

Ex. If my column contains "email@email.com" and "email@email.com", only one of these will be highlighted. I need both to be highlighted.

I'll include a screenshot to clarify this further:
As you can see, only one of the duplicates is highlighted + a single value is highlighted, letting me think that the duplicate for "8293227@gmail.com" might be elsewhere but I can't find it.

Illustrative screenshot here

Thanks in advance for your help! 🙏

答案1

得分: 1

条件格式化将突出显示重复项,但不会移动它们。

如果您进行排序,基于特定列,那么重复项应该是连续的。但是,如果您按不同的列进行排序,那么将控制排序顺序。

没有一些示例数据很难猜测发生了什么,但是在这里,前导或尾随空格是一个非常常见的错误,经常出现在这个堆栈上。

例如,您可以在下面看到突出显示的重复项:

为什么对电子邮件列进行排序时,重复的电子邮件不会显示在彼此下方?

英文:

Conditional formatting will highlight duplicates but it will not move them.

If you do a sort, based on that particular column then the duplicates should be sequential. However if you are sorting by a different column then that will control the sorted order.

It is difficult to guess what is happening without some example data, but leading or trailing spaces is a VERY common error here and comes up often on this stack.\

As an example, you can see duplicates highlighted below:

为什么对电子邮件列进行排序时,重复的电子邮件不会显示在彼此下方?

huangapple
  • 本文由 发表于 2023年7月24日 17:10:17
  • 转载请务必保留本文链接:https://go.coder-hub.com/76752948.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定