+ Reply to Thread
Results 1 to 4 of 4

Delete rows

  1. 07-15-2011, 01:48 PM #1
    nicolaforni is offline
    Registered User
    Join Date
    10-19-2008
    Location
    UK
    Posts
    63

    Smile Delete rows

    I need to delete rows that have the same item.

    Ex.
    Range A3:C6

    1 apples france
    2 pears italy
    3 bananas costa rica
    4 pears italy

    The duplicate is found in second column (so B:B) in this case it is pears.
    Data on other columns (1 and 3) can be the same only second column is criteria for deletion.

    Thanks,
    Nix
    Last edited by nicolaforni; 07-18-2011 at 01:11 PM.
    Reply With QuoteRegister To Reply
  2. 07-15-2011, 02:27 PM #2
    davegugg is offline
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Delete rows 

    Please Login or Register  to view this content.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave
    Reply With QuoteRegister To Reply
  3. 07-15-2011, 02:44 PM #3
    realniceguy5000 is offline
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Delete rows

    Another way Maybe?
    Please Login or Register  to view this content.
    Thank You, Mike

    Some Helpful Hints:

    1. New members please read & follow the Forum Rules
    2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
    3. If you are pleased with a solution mark your post SOLVED.
    4. Thank those who have help you by clicking the scales at the top right of the post.

    Here...
    Reply With QuoteRegister To Reply
  4. 07-18-2011, 01:09 PM #4
    nicolaforni is offline
    Registered User
    Join Date
    10-19-2008
    Location
    UK
    Posts
    63

    Re: Delete rows

    Thanks!
    :-)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1