How to find and remove duplicates in excel Step by step with examples?

Find and remove duplicates

Sometimes duplicate data is useful, sometimes it just makes it harder to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them.

Please refer below steps

v Select the cells you want to check for duplicates.

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

conditional formatting

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

Highlight Duplicate cells

P.S:- Please check Highlighted Data before moving next steps 

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

For example, in this worksheet, the January column has price information I want to keep.

So, I unchecked January in the Remove Duplicates box.

Click OK.

You may also like

Learn about SEO

By admin

Leave a Reply

Your email address will not be published.