英文:
Why does sorting a column of emails not show duplicates under each other?
问题
我正在尝试在Google表格列中标记重复的电子邮件地址。我不能使用“删除重复项”功能,因为我需要标记它们,而不是删除它们。
当我使用条件格式设置来突出显示重复项,然后对列进行排序时,我注意到重复的电子邮件不会出现在彼此下面。
我使用了这个自定义公式的条件格式:“=COUNTIF($A$2:$A$10, A2)>=2”
但我有两个问题:
-
当我将电子邮件列从A到Z排序时,一些突出显示的值(重复项)不会出现在彼此下面。我不明白为什么会这样,因为只应用了一次排序。
-
这个公式只突出显示了重复的值,而不是“原始值”(被复制的值)。
例如,如果我的列包含“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:
-
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.
-
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.
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:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论