1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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