In the previous article I wrote about How To Remove Duplicates Data In Microsoft Excel, using that tips you can remove duplicate data without knowing specific data that you removed. How about if you want to identify duplicates data which is may exist in excel file before you remove?
You can use Excel's Conditional Formatting tool to highlight duplicate entries in a list. Follow the step below:
1. For example you have data such us below:
2. On the Home tab, select Conditional Formatting -> Highlight Cells Rules -> Duplicate Values
3. Click Ok, then you will see duplicate entries in your excel file
If you want to clear the highlight cells, go to Conditional Formatting -> Clear Rules-> Clear Rules from Entire Sheet
Related Topics:
How to configure Word, Excel 2007 options to save file into 97-2003 format?
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
How to find Duplicate entries in Microsoft Excel 2007
Easy tips to delete blank rows in Excel
Easy tips to create graphic in Excel
Microsoft Excel 2007: How to take limit value to the cell
No comments:
Post a Comment