![excel formula to remove duplicates from a list excel formula to remove duplicates from a list](https://www.get-digital-help.com/wp-content/uploads/2009/03/Filter-a-unique-distinct-list-and-remove-blanks-1.png)
Excel can see that there is data in column B so it asks us to Expand the selection or Continue with the current selection. Now we will try to remove duplicate data from the advanced filter Advanced Filter To use an advanced filter first we have to define a criteria for the auto filter and then click on the Data tab and then in the advanced section for the advanced filter where we will fill our criteria for the data read more tool.
![excel formula to remove duplicates from a list excel formula to remove duplicates from a list](https://d13ot9o61jdzpp.cloudfront.net/images/formula_to_sort_list.png)
How you remove duplicates is also a common topic brought up during a job interview that requires Excel knowledge.
![excel formula to remove duplicates from a list excel formula to remove duplicates from a list](https://1.bp.blogspot.com/-LlVjNoFXYHg/Xa_KzBYvHQI/AAAAAAAABeE/ttDEM_nRXc8F6f0RNP1IKA7oPDU85YSNgCLcBGAsYHQ/s1600/What-is-the-duplicates-formula-in-Excel.png)
You can additionally specify which columns are to be checked. I need to remove the duplicate values from the CompanyLookup column (Company A has an entry for the President, Vice President, etc.). I have a list in SharePoint with a PowerApps form that has a lookup column to this list of leaders and companies. If we go back to our example of our team of salesmen, to create the table of salesmen, rather than typing them out manually we can create a list of unique names and copy them to the new table. I have a master SharePoint list of all the leaders of the smaller companies under the parent umbrella. We can use the Remove Duplicates button to create unique lists of data stored in your spreadsheets. In Excel, the Remove Duplicates function can help users to quickly remove all duplicate values from a list. Particularly in very large Excel workbooks, duplication is common place and very difficult to spot. Using Excel 2007 and Excel 2010 to remove duplicates from your workbook