Closed Thread
Results 1 to 2 of 2

How to delete multiple rows but that match in certain columns please help

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    6

    How to delete multiple rows but that match in certain columns please help

    ertret.jpg





    Please help me, I am trying to delete rows that contain the same addresses BASED ON COLUMNS.

    Do you see how in columns C and D they all match EXCEPT for row 4? How do I delete allllll the rows that when c and d match.
    I want to keep the ones that DO NOT MATCH. Please help me thank you.

    P.S I HAVE 4000 ROWS I WOULD HAVE TO GO THROUGH

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How to delete multiple rows but that match in certain columns please help

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/excel-form...f-columns.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find exact match in multiple columns in 1 row with all other rows 90,000 rows.
    By KHurt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-02-2013, 01:38 PM
  2. Replies: 9
    Last Post: 12-20-2012, 10:29 AM
  3. [SOLVED] If certain columns in a row match the rows beneath then sum a specifc column and delete
    By wbrown in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-14-2012, 12:01 PM
  4. Delete rows that match multiple criteria
    By gsrai31 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2010, 09:30 AM
  5. Sum and delete rows if columns A match
    By sg9207 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2010, 08:05 PM

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