Results 1 to 9 of 9

Thread: Delete Rows where data is the same but in different columns

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    Delete Rows where data is the same but in different columns

    I have values in Col F and G. Where the value in Col F is the same as in Col G and the control (ref #) in Col E is the same, then the rows contain this criteria are to be deleted

    I have highlighted the items in yellow where the values in Col F & G are the same and the control numbers match (i.e the control numbers are the same)

    I have attempted a macro, but cannot get it to work

    Your assistance is most appreciated
    Attached Files Attached Files

Similar Threads

  1. seprate data in rows to columns
    By CORAL in forum Excel Help
    Replies: 2
    Last Post: 03-10-2014, 08:18 AM
  2. search for data and delete rows containing it
    By RickStewart in forum Excel Help
    Replies: 2
    Last Post: 02-24-2014, 09:12 PM
  3. Replies: 10
    Last Post: 02-18-2014, 01:34 PM
  4. Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  5. Replies: 5
    Last Post: 07-11-2013, 07:31 AM

Posting Permissions

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