How to erase duplicate lines in EXCEL?

Discussion in 'Products & Tools' started by medaa25, Jan 30, 2008.

  1. #1
    Anyone know of a solution to erase duplicate lines in Excel?


    Rep to the first person who finds me the solution... :D
     
    medaa25, Jan 30, 2008 IP
  2. picobello

    picobello Well-Known Member

    Messages:
    572
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    110
    #2
    On how many columns?
    A macro could do

    PM me the details, I will try to provide quick help
     
    picobello, Jan 30, 2008 IP
  3. NsaneNoob

    NsaneNoob Peon

    Messages:
    2,103
    Likes Received:
    59
    Best Answers:
    0
    Trophy Points:
    0
  4. medaa25

    medaa25 Active Member

    Messages:
    388
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    60
    #4
    Thank you for your reply.

    1 column only. Can you provide a step by step? I don't know anything about "macro" or anything...

    Thank you again for your help!
     
    medaa25, Jan 30, 2008 IP
  5. medaa25

    medaa25 Active Member

    Messages:
    388
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    60
    #5
    medaa25, Jan 30, 2008 IP
  6. NsaneNoob

    NsaneNoob Peon

    Messages:
    2,103
    Likes Received:
    59
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Glad to help.
     
    NsaneNoob, Jan 30, 2008 IP
  7. picobello

    picobello Well-Known Member

    Messages:
    572
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    110
    #7
    picobello, Jan 31, 2008 IP
    medaa25 likes this.
  8. medaa25

    medaa25 Active Member

    Messages:
    388
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    60
    #8
    Picobello,

    Thank you for your help.

    Rep added!
     
    medaa25, Jan 31, 2008 IP