How to Filter for Unique Values & Remove Duplicates in Microsoft Excel

Learn how to find and remove duplicates​, count unique values among duplicates​, and use the new unique function.

At the end, I cover how to use Excel for free on the web. Excel on the web supports conditional formatting to find unique values and duplicates, remove duplicates, and the new unique formula.

The new unique formula is currently only available to Office Insiders. It will be available to all users soon. To try it out, you can opt into being an Office Insider from within Excel.

Here's the sheet I used if you want to follow along:


As full-disclosure, I work at Microsoft as a full-time employee.

excel,tutorial,office,microsoft,data,analyze,office 365,excel 365,excel 2019,excel 2016,excel 2013,excel 2007,excel 2010,microsoft office,microsoft excel,help,how to,guide,step by step,formulas,formula,function,functions,x lookup,index,match,365,360,rows,columns,row,column,cell,countif,condition,criteria,unique,unique function,=unique(),insider,filter,value,values,duplicate,duplicates,remove,remove duplicates,