+ Reply to Thread
Results 1 to 5 of 5

automated row erasing in excel

  1. #1
    Forum Contributor
    Join Date
    05-12-2008
    Location
    Schleswig-Holstein, Germany
    MS-Off Ver
    2010
    Posts
    102

    automated row erasing in excel

    Hello everybody,

    I hope I can find here some help or ideas for solving the next issue: I'm an electric engineer who works with a software able to export lists under the excel format. Those lists include several times repeated elements in the cells.....As an image is better than thousand words, I just want to show you the next screen capture .

    In this screen capture you can see that it is repeated, for instance, the element "KA13" 5 times. What I'd like to do is to get the exported lists "lighter" by removing the repeated 4 of the five repeated rows. I guess this must be done randomly since the adjacent cells in the same row have no logical conection between . I mean that you can't sort them by any criteria: The A column format is an index of pages and the B, C and D are referred to other parameters.

    Any ideas of how to implement an excel program for achieving this?

    Thanks in advance
    Attached Images Attached Images
    Last edited by buhnen; 05-12-2008 at 09:01 AM.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Based on the picture that you have shown, this macro should delete all reoccurrences of a value in column E, besides the first one.

    Instructions:
    Press Alt + F11 to open the VBE.
    Go to INSERT-MODULE
    Copy the code below and paste it into the module
    Run the macro

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-12-2008
    Location
    Schleswig-Holstein, Germany
    MS-Off Ver
    2010
    Posts
    102

    Great Job !!!

    Great job BigBas,

    Your macro works really fine, congratulations! :-)...I only forgot to mention that the E column has empty cells as well that should be erased, but that's a minor detail anyway. It can always be done manually.

  4. #4
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Why do it manually if the system can do it for you?

    Use this modified code to delete rows where (1) the value in column E is duplicated or (2) the value in Column E is blank.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    05-12-2008
    Location
    Schleswig-Holstein, Germany
    MS-Off Ver
    2010
    Posts
    102
    Thanks again Bigbas!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1