Tips on Finding Duplicates Data In Excel
How to searching for duplicates data entries on Microsoft Excel?The following tips to find duplicate data in a excel sheet. If there is just little of entries, may be searches the duplicates data one by one is not a big problem. But what if the data is thousands or even more? The following tips may help. Tips are tested using Excel 2007/2010.
- Block the column of data to be checked.
- On the Home tab, select Conditional Formatting - Highlight Cells Rules - Duplicates Values - click OK.
- If there is the same data on each of cells, it will be given a different color. So it can be seen clearly if found duplicates data.
Posted by A Faqihuddin Latheif on 2012-12-05 20:41:33 Categorized in :, Sharing