Tuesday, July 15, 2014

Remove duplicates in Excel

  1. make a selection
  2. go to the "DATA" tab
  3. click the "Advanced" button by the "Filter" button
  4. in the "Advanced Filter" dialog box check the "Unique records only" checkbox
  5. copy your list elsewhere with the power of the "Advanced Filter" dialog box
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)