 Ask
The Technology Therapist...
Learn How To Remove Duplicates From Your
Excel Lists
If you find this tip helpful:
Do you use Excel to manage your lists? Contact
lists, financial lists any data lists at all. Have you ever
wanted to find duplicates in your list? With Excel 2007
this new feature has made managing and finding duplicates
as easy as clicking a button.
 First click into or select your list. Then click the Tab marked
Data on your ribbon. You will see a button marked remove duplicates.
A pop-up window will appear, choose the column
that you believe contains the duplicates and uncheck the
columns that do not and click OK.
If your column has duplicates they will have
been removed. 
See easy as pressing a button.
This is Jennifer Shaheen The Technology
Therapist with your technology tip of the week.
If you find this tip helpful:
|
