![excel find duplicates in multiple columns excel find duplicates in multiple columns](https://i.stack.imgur.com/3bNiy.png)
Choose a destination for the filtered list in the Copy to This can be on the same sheet or in another sheet.Check to see that Excel has correctly identified the data you wish to filter in the List range: text box and select or correct the range if not.
![excel find duplicates in multiple columns excel find duplicates in multiple columns](https://cdn.extendoffice.com/images/stories/doc-excel/highlight-duplicates-across-columns/doc-highlight-duplicate-across-columns-1.png)
![excel find duplicates in multiple columns excel find duplicates in multiple columns](https://cdn.extendoffice.com/images/stories/doc-excel/find-duplicates-in-two-columns/doc-find-duplicates-8.png)
#Excel find duplicates in multiple columns windows 7
Images were taken using Excel 2013 on the Windows 7 OS so the specific steps may vary based on your version. The following steps apply to Excel 2007-2013. This article covers three of those methods and a scenario in which you might use them. Excel gives you several ways to do this, depending on your data and what results you are after. The end result is that you need to find and manipulate duplicates. It’s a common scenario: Data is combined from multiple sources, records are entered by multiple users or you simply have multiple transactions with the same information. By Tepring Crocker Categories: Excel® Tags: find duplicates