在Excel中查找重复的行 [英] Finding duplicate rows in excel

问题描述

我有两行的Excel电子表格.一个用于名称，另一个用于ID.有什么办法可以找到具有完全相同ID的行，并让我轻松地看到它们?例如，我有以下行:

I have an excel spreadsheet with two rows. One is for name, and the other is for id. Is there any way i can find the rows that have the exact same id and allow me to easily see those? For example i have the rows:

Name:     Id
Hello     1
World     5
Mylo      1
Jack      6
Jil       9
Frank     5

因此，在上面的示例数据中，excel应该以某种方式用hello和mylo以及world和frank标记行，以指示这些ID有重复的ID.

So in the above example data, excel should somehow mark the rows with hello and mylo and world and frank to indicate that there are duplicate id's for those

推荐答案

绝对最快，最简单的方法.条件格式，突出显示重复项(在ID列上).然后按颜色(在复选框上方)过滤列(可能在表格中).

The absolute fastest and easiest way. Conditional formatting, highlight duplicates (on the ID column). Then filter the column (presumably in a table) by the coloring (above the check boxes).

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