If you have Excel 2007, you can use conditional formatting to find duplicate data in your spreadsheet. For example, if you have a list of employees, and you want to find the employees who have the same name as a certain person, you can use the following code: SELECT * FROM employee This will return all the data for employees who have the same name as a certain person.
With the Excel document open highlight the section of the document to search for duplicate entries.
On The Ribbon click under the Home Tab is selected.
In the Styles section click on Conditional Formatting \ Highlight Cells Rules \ Duplicate Values.
This opens up the Duplicate Values dialog box where you can select how to format the cells with duplicate data.
Now you will be able to easily find the cells that contain the duplicate data so you can change the values or delete them.
This is a quick and easy tip to help make sure important spreadsheets contain correct information.
