excel 删除重复项
If I need a list of unique items from a long list, I usually use an Advanced Filter, because it leaves the original list alone, and extracts a list of unique records. The filter can be done in place, or sent to another range, on the same sheet, or a different sheet. It's easier in newer versions of Excel though - here's how to quickly remove duplicates in Excel 2013.
如果需要长列表中的唯一项列表,则通常使用Advanced Filter ,因为它不考虑原始列表,而是提取唯一记录列表。 过滤器可以在同一张纸上或在另一张纸上就地完成,或发送到另一个范围。 不过,在新版本的Excel中更容易-这是在Excel 2013中快速删除重复项的方法。
This screen shot shows the Advanced Filter dialog box, which lets you extract a list of unique records.
此屏幕快照显示了“高级筛选器”对话框,可让您提取唯一记录的列表。
删除重复工具 (Remove Duplicates Tool)
In Excel 2007, the Remove Duplicates tool was introduced, and I wrote about that a few years ago. It’s a quicker way to strip duplicates out of a list, but it works on the original list – it doesn’t create a separate list of unique items.
在Excel 2007中,引入了“删除重复项”工具,几年前我就写过有关此内容的文章。 这是从列表中删除重复项的较快方法,但它适用于原始列表-不会创建单独的唯一项目列表。
The tool still works the same way, in Excel 2013, and I’ve finally made a video to show how it works. You can use it on a single column list, or a list with two or more columns.
该工具在Excel 2013中仍然以相同的方式工作,我终于制作了一个视频来演示其工作原理。 您可以在单列列表或两列或更多列的列表上使用它。
Add check marks for the columns that you want to check for duplicates, then click OK.
为要检查重复的列添加复选标记,然后单击“确定”。
And remember, make a backup before you start! If you’ve bought a copy of my Excel Tools add-in, just click the “Make Backup” button.
请记住,在开始之前进行备份! 如果您购买了我的Excel Tools加载项的副本,只需单击“进行备份”按钮。
视频:在Excel 2013列表中删除重复项 (Video: Remove Duplicates in Excel 2013 List)
To see the steps for removing duplicates from a list in Excel 2013, please watch this video. The steps are the same in Excel 2007 and 2010. Remember to make a backup of the file, or the list, before you start.
要查看在Excel 2013中从列表中删除重复项的步骤,请观看此视频。 这些步骤在Excel 2007和2010中相同。在开始之前,请记住对文件或列表进行备份。
翻译自: https://contexturesblog.com/archives/2013/11/26/remove-duplicates-in-excel-2013-list/
excel 删除重复项