How to find and remove duplicates in Excel?



To find the duplicates in Excel


  • Select the cells you want to check for duplicates.

  • Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.



 


  • In the box next to values with, pick the formatting you want to apply to the duplicate values, and then click OK.



 





To remove duplicates in Excel


  •  Select the range of cells that has duplicate values you want to remove.

  • Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.



 


  • Click OK.



Share :

Facebook Twitter
Back To Top

facebook

Powered by Blogger.