#How to find duplicates in excel how to#
Now we need to figure out how to flag any repeating SKU as a duplicate. To to Add Column –> Add Index Column –> From 0.The reason will become apparent later, but for now: This might seem like an odd step right now, but we’re going to add a Index column to this table as well. Changed Type (setting the data types for the columns).The data will be loaded in to Power Query, and you’ll see two steps in the Applied Steps window: Of course we’ll start by pulling the data in to Power Query I’m carving off one method that is the easiest to replicate via the user interface… Step 1: Link to the Data
![how to find duplicates in excel how to find duplicates in excel](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/04/Remove-Duplicates-from-Excel-Column.jpg)
Naturally, there will be a few different ways to do this. Instead you’d like to identify which records have duplicate entries in the list. While it would be easy to just hit the SKU column with the Remove Duplicates function, you don’t want to do that. While the list provided to you was supposed to be duplicate free, you’re not 100% sure that it actually is. While multiple brands are okay here, we need a list that shows only unique SKU numbers. Suppose someone has given you a list like the one shown below (which you can download here if you’d like to follow along):
![how to find duplicates in excel how to find duplicates in excel](https://cdn.ablebits.com/_img-blog/excel-compare-two-columns/compare-2-columns-mark-duplicates.png)
Some time ago I got an email from Alex asking me if there was a way to identify duplicates using Power Query, but without removing non-duplicate records in the process.