For Excel experts!

Discussion in 'Software Q&A' started by sms_solver, Sep 26, 2004.

Thread Status:
Not open for further replies.
  1. sms_solver

    sms_solver New Member

    Joined:
    Jan 2, 2004
    Messages:
    420
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    somewhere
    Is there any hidden features in excel to remove duplicate items from a column full of data.

    Excel can sort any column, but I need sorting as well as removing duplicate items from the column.

    I know there is VBA with excel, but I don't want to spend few hours making custom module for this task.

    Is there any readymade Addin available, or code

    help me!
     
  2. it_waaznt_me

    it_waaznt_me Coming back to life ..

    Joined:
    Nov 30, 2003
    Messages:
    2,023
    Likes Received:
    10
    Trophy Points:
    38
    Location:
    A bit closer to heaven
    Hmm .. You wanna hide them or delete them ..?
    If you wanna hide them you can put a filter to hide duplicate items...
     
  3. OP
    OP
    sms_solver

    sms_solver New Member

    Joined:
    Jan 2, 2004
    Messages:
    420
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    somewhere
    I want to remove duplicate item from column list

    I have found out the solution

    -> copying column data from excel
    -> pasting it in EditPlus new text file
    -> then sorting+removing duplicate (there is option in this program)
    -> copying back to excel

    this tips may be useful to someone
    :)
     
  4. visvo

    visvo New Member

    Joined:
    Feb 3, 2004
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    nagpur
    hey ! u can do that in excel too by using find command and then delete it .its simple no need for editplus here
     
  5. xenkatesh

    xenkatesh Bewitched!

    Joined:
    Feb 7, 2004
    Messages:
    468
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    chennai
    thats cool nice information!
     
Thread Status:
Not open for further replies.

Share This Page