 |  |  |  |  |  |
|
Deleting duplicate records in Excel- March 2006 |
||||||||||||||||||
|
Deleting duplicate records in Excel is a question we are often asked during training courses. To do this you have to filter for unique records and then use the resulting rows as your new list. Read on .... |
||||||||||||||||||
|
Filtering for unique records
|
To filter for unique records first click in a cell within your list. From the Data menu choose Filter and then choose Advanced Filter. In the Advanced Filter dialog box click Copy to another location. In the copy to box, either type the cell reference where you want the copy to appear, or scroll down to find the cell and click in the cell. Select the Unique records only check box and then click OK. Now check your new list, any duplicate records will not be included. |
|
||||||||||||||||
|
Replacing your original list
|
You can either cut and paste your new list on top of the original list or alternatively delete the original list and any blank rows above the new list. Make sure that when you have finished your list conforms to the standard list rules that Excel expects when working with a list. |
|||||||||||||||||
|
What are Excels list rules?
|
When working with a list in Excel:
|
|||||||||||||||||
|
Home
- Services - Courses
- Prices - Hints/Tips
- Contact Us
|
||||||||||||||||||
 |
|
|
|
|||||||||||||||
