Results 1 to 3 of 3

Removing duplicates

This is a discussion on Removing duplicates within the Excel Questions forums, part of the Question Forums category; How can I search an excel document and remove duplicates?...

  1. #1

    Join Date
    Feb 2003
    Posts
    217

    Default

    How can I search an excel document and remove duplicates?

  2. #2
    MrExcel MVP phantom1975's Avatar
    Join Date
    Jun 2002
    Location
    Omaha, Nebraska
    Posts
    3,947

    Default

    You can always do a FIND and REPLACE. You would have to do it manually. The alternative would be a macro. I can customize a macro for you if you offer the criteria. What is the range of cells? How many sheets?
    Silly Billy was here....

    ***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************

  3. #3
    New Member
    Join Date
    Feb 2003
    Location
    Middlesbrough, UK
    Posts
    7

    Default

    How about

    Data
    Filter
    Advanced Filter
    Select List range
    tick Unique Records Only


Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com