Learn to filter and copy unique records in an Excel list

Frequently, you need to find and copy the unique records in an Excel data list. For example, you might be preparing to send out a direct mail piece and you want to clean you list first.

Having the unique records copied to another location might help you to spot glaring errors from faulty data entry.

Here are the steps to follow in this video lesson:

  1. Highlight the data that contains the records you wish to filter. This could be the entire data lis or just one column / field.
  2. Select Data, Filter, Advanced Filter. Be sure to select “Copy to another location and to check the “Unique records only” box.
  3. Click the starting cell where you want to place the copied “Unique records” and then click OK.
  4. You may wish to use the AutoFilter to select the data entry errors for correction.

Find the Excel Video Lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


Speak Your Mind