Select data columns: In the table, click and drag the mouse to select columns that contain duplicate data. If you want to filter for duplicates in the entire table, please select all columns.
Apply Conditional Format: In the toolbar at the top of Excel, click on the "Start" tab (which may appear as the "Edit" tab in older versions of Excel), and then click on "Conditional Format".
选择规则：在弹出的条件格式菜单中，选择突出显示单元格规则。
Selection rules: In the pop-up conditional format menu, select [Highlight Cell Rules].
筛选重复值：在打开的规则对话框中，您会看到多个选项。选择【重复值】选项。
Filter duplicate values: In the opened rule dialog box, you will see multiple options. Select the option for duplicate values.
确定并应用： 点击【确定】按钮，Excel会自动将所选列或表格中的重复值突出显示。
Confirm and Apply: Click the [OK] button, and Excel will automatically highlight duplicate values in the selected column or table.
Sorting and filtering: If you want to separate the filtered duplicate data from the original data, you can click on the "Data" tab and then select the "Sorting and filtering" option.
Filter by Color: In the sorting and filtering menu, select [Filter by Color]. If you have previously highlighted duplicate values as a color, then selecting that color will filter out all duplicate values.
Delete duplicates: Now you can delete the filtered duplicate rows or copy them to another location for further analysis. By following the above steps, you can effectively filter out duplicate data in Excel. This method not only helps you clean up the dataset, but also avoids the interference of duplicate data during the analysis process.
二、Excel中自动排序。
Automatically sort in Excel。
打开Excel表格：启动Excel程序，然后打开包含您要排序数据的表格文件。
Open Excel spreadsheet: Start the Excel program, and then open the spreadsheet file containing the data you want to sort.
选择要排序的数据列：在表格中，点击并拖动鼠标以选择您想要排序的列。
Select the data columns to sort: In the table, click and drag the mouse to select the columns you want to sort.
Application sorting: In the toolbar at the top of Excel, click on the "Start" tab (which may appear as the "Edit" tab in older versions of Excel), and then click on "Sort and Filter".
Confirm and Apply: Click the [OK] button, and Excel will automatically sort the selected columns according to the sorting type you have selected. By following the above steps, you can automatically sort data in Excel. This method can help you better analyze and understand data, and improve work efficiency.
杰x分享（9）：Excel自动排序和筛选重复数据的方法详解
在日常的工作中，Excel的使用频率相当高，如何有效地对数据进行排序和筛选是提高工作效率的关键之一。本文将详细介绍如何利用Excel的功能进行自动排序和筛选重复数据，让我们能够轻松地处理大量数据，并快速找到所需信息。通过学习这些方法，我们可以节省大量的时间和精力，让工作更加高效和便捷。
分享兴趣，传播快乐，
增长见闻，留下美好。
亲爱的您，这里是LearingYard学苑！
今天小编为您带来关于Excel如何自动排序与筛选重复数据的方法
欢迎您的访问！
Share interest, spread happiness,
increase knowledge, and leave beautiful.
Dear, this is the LearingYard Academy!
Today, the editor will bring you how to automatically sort and filter duplicate data in Excel
Welcome to visit!
思维导图Mind mapping
一、Excel中筛选重复数据。
Filter duplicate data in Excel.
打开Excel表格：启动Excel程序，然后打开包含您要筛选数据的表格文件。
Open Excel spreadsheet: Start the Excel program, and then open the spreadsheet file containing the data you want to filter.
选择数据列；在表格中，点击并拖动鼠标以选择包含重复数据的列。如果您想要筛选整个表格中的重复项，那么请选中所有列。
Select data columns: In the table, click and drag the mouse to select columns that contain duplicate data. If you want to filter for duplicates in the entire table, please select all columns.
应用条件格式；在Excel顶部的工具栏中，点击【开始】标签（在旧版本的Excel中可能显示为【编辑】标签），然后点击【条件格式】。
Apply Conditional Format: In the toolbar at the top of Excel, click on the "Start" tab (which may appear as the "Edit" tab in older versions of Excel), and then click on "Conditional Format".
选择规则：在弹出的条件格式菜单中，选择突出显示单元格规则。
Selection rules: In the pop-up conditional format menu, select [Highlight Cell Rules].
筛选重复值：在打开的规则对话框中，您会看到多个选项。选择【重复值】选项。
Filter duplicate values: In the opened rule dialog box, you will see multiple options. Select the option for duplicate values.
确定并应用： 点击【确定】按钮，Excel会自动将所选列或表格中的重复值突出显示。
Confirm and Apply: Click the [OK] button, and Excel will automatically highlight duplicate values in the selected column or table.
排序和筛选：如果您想要将筛选出的重复数据从原始数据中分离出来，可以点击【数据】标签，然后选择【排序和筛选】选项。
Sorting and filtering: If you want to separate the filtered duplicate data from the original data, you can click on the "Data" tab and then select the "Sorting and filtering" option.
按颜色筛选：在排序和筛选菜单中，选择【按颜色筛选】。如果您之前已将重复值突出显示为一种颜色，那么选择该颜色，所有重复值将被筛选出来。
Filter by Color: In the sorting and filtering menu, select [Filter by Color]. If you have previously highlighted duplicate values as a color, then selecting that color will filter out all duplicate values.
删除重复项：现在您可以将筛选出的重复行删除，或者复制到另一个位置进行进一步的分析。通过以上步骤，您可以在Excel中有效地筛选出重复数据。这个方法不仅可以帮助您清理数据集，还可以在分析过程中避免重复数据的干扰。
Delete duplicates: Now you can delete the filtered duplicate rows or copy them to another location for further analysis. By following the above steps, you can effectively filter out duplicate data in Excel. This method not only helps you clean up the dataset, but also avoids the interference of duplicate data during the analysis process.
二、Excel中自动排序。
Automatically sort in Excel。
打开Excel表格：启动Excel程序，然后打开包含您要排序数据的表格文件。
Open Excel spreadsheet: Start the Excel program, and then open the spreadsheet file containing the data you want to sort.
选择要排序的数据列：在表格中，点击并拖动鼠标以选择您想要排序的列。
Select the data columns to sort: In the table, click and drag the mouse to select the columns you want to sort.
应用排序：在Excel顶部的工具栏中，点击【开始】标签（在旧版本的Excel中可能显示为【编辑】标签），然后点击【排序和筛选】。
Application sorting: In the toolbar at the top of Excel, click on the "Start" tab (which may appear as the "Edit" tab in older versions of Excel), and then click on "Sort and Filter".
确定并应用：点击【确定】按钮，Excel会自动按照您选择的排序类型对所选列进行排序。通过以上步骤，您可以在Excel中自动排序数据。这个方法可以帮助您更好地分析和理解数据，提高工作效率。
Confirm and Apply: Click the [OK] button, and Excel will automatically sort the selected columns according to the sorting type you have selected. By following the above steps, you can automatically sort data in Excel. This method can help you better analyze and understand data, and improve work efficiency.
今天的分享就到这里了。
如果您对今天的文章有独特的想法，
让我们相约明天。
祝您今天过得开心快乐！
That's all for today's sharing.
If you have a unique idea about the article,
please leave us a message,
and let us meet tomorrow.
I wish you a nice day!
参考资料：谷歌翻译、百度
本文由LearningYard新学苑整理并发出，如有侵权请后台留言沟通