Checking a lot of duplicate data in excel is a hard job. It is easy check one by one data if the data only 10 or 20 rows, how about if you have more than 1000 data?
In Microsoft Excel You can specify which column should be checked for duplicate information.
By following these tips below you can easy to find and delete duplicate data in Excel.
1. Open your Excel data then Select the range of cells, or make sure that the active cell is in a table.
2. On the Data tab, in the Data Tools group, click Remove Duplicates.
3. A message is displayed indicating how many duplicate values were removed and how many unique values remain, or if no duplicate values were removed.
Related Topics:
How to Repair corrupted files 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 Remove Duplicates Data In Microsoft Excel
Easy Tips To Add Date And Time In Microsoft Excel
How to separate the cell contents in Microsoft Excel
No comments:
Post a Comment