Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    finding and eliminating duplicate wrods in MS Word (2003)

    Hi is there an easy way to find duplicate entries and eliminate them? I tried find and replace but that deos not work. The idea is I have a list of products i.e., "electric chainsaws" and some are listed multiple times and I want to elininate all but one from the document.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: finding and eliminating duplicate wrods in MS Word (2003)

    Could you attach a small sample document that shows us what you're working with?

  3. #3
    Star Lounger
    Join Date
    Oct 2003
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: finding and eliminating duplicate wrods in MS Word (2003)

    ofcourse!
    Attached Files Attached Files

  4. #4
    Star Lounger
    Join Date
    Oct 2003
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: finding and eliminating duplicate wrods in MS Word (2003)

    or here's where the data originated from
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: finding and eliminating duplicate wrods in MS Word (2003)

    It's much easier to do this in Excel than in Word, so since the data apparently come from Excel originally, I'd use that. Are you familiar with Data | Filter | Advanced Filter in Excel?

  6. #6
    Star Lounger
    Join Date
    Oct 2003
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: finding and eliminating duplicate wrods in MS Word (2003)

    No I am not familiar with the feature but I tried it anyway and I keep getting the first row repeated, otherwise it looks promising. Couid you show me briefly?

    Regards,
    aluislugo
    Attached Files Attached Files

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: finding and eliminating duplicate wrods in MS Word (2003)

    Great, you essentially did it correctly. But when using filters, Excel treats the topmost items as column headers (field names). The first instance of RL.IS.REV.0002 in the copied items is a dummy column header. You can either ignore/delete it, or do the following:
    - Enter a dummy header of your own in A1 and in E1.
    - Now apply Advanced Filter with the Copy to and Unique records only options, with cell A1:A44 as list range and E1 as target.
    - Voila! You may want to sort column E to get rid of the blank cell.

  8. #8
    Star Lounger
    Join Date
    Oct 2003
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: finding and eliminating duplicate wrods in MS Word (2003)

    Thank you Hans you are ALWAYS very helpful. And because of you from time to you make me look smart at work ;0)

    Regards.

Posting Permissions

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