Using OpenOffice calc to find duplicates in word lists?

Discussion in 'General Chat' started by Kerosene, Dec 13, 2007.

0
  1. #1
    I've got 2 lists of of products, with apx 2000 item in each list.

    Is there a way I can check one list against the other and remove/highlight any duplicates?

    I want each list to be unique.

    OpenOffice gurus - please help me :)
     
    Kerosene, Dec 13, 2007 IP
  2. SFOD_D223

    SFOD_D223 Peon

    Messages:
    4,512
    Likes Received:
    174
    Best Answers:
    0
    Trophy Points:
    0
    #2
    << not an open office guru. but if this calc deal is anything like excel. is there a way to "search" for certain phrases like in a word document?
     
    SFOD_D223, Dec 13, 2007 IP
  3. Kerosene

    Kerosene Alpha & Omega™ Staff

    Messages:
    11,366
    Likes Received:
    575
    Best Answers:
    4
    Trophy Points:
    385
    #3
    Yes you can do a search in OO. But I really need a "compare & copy duplicates" filter/formula...
    ------
    EDIT - Problem solved.
    Thought I'd post the answer in case anyone else ever needs to do the same thing. I found some great software to compare lists, it's not free but it rocks
    : http://www.sobolsoft.com/listremove/
     
    Kerosene, Dec 13, 2007 IP
  4. dpsubi1

    dpsubi1 Notable Member

    Messages:
    9,318
    Likes Received:
    420
    Best Answers:
    0
    Trophy Points:
    280
    #4
    I haven't worked on open office calc. but in excel you can use count if function to find duplicates
     
    dpsubi1, Dec 4, 2009 IP