Results 1 to 12 of 12

If Column A = Value & Column B = Value in Same Row THEN Delete Row

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2011
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    26

    If Column A = Value & Column B = Value in Same Row THEN Delete Row

    Hello Everyone,

    I'm looking to search all rows within a sheet for one value in Column A, and then when it finds that value, identify the rows that have a second value in Column B as well. Once that is found, delete the row.

    For example,

    A B
    22222 111
    22222 222
    22222 333

    Find the row that has 22222 is column A & 222 in column B, and delete this row. If you can please help me make the code using this 22222 222 combo as an example, I can edit the numbers for a few exceptions I need it for.

    Thanks!
    Last edited by perdooky; 01-12-2012 at 06:01 PM.

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