Results 1 to 6 of 6

VBA Excel: Identifying a row, then comparing columns in that row and deleting duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2017
    Location
    UK
    MS-Off Ver
    2010
    Posts
    17

    VBA Excel: Identifying a row, then comparing columns in that row and deleting duplicates

    The aim in mind is to identify a row that has 'US Control Injection'
    Then compare cell A, Cell F, Cell H and Cell O with all other rows.
    Any rows that match all 4 of these cells can then be deleted along with the originally identified row.
    I need to match so many cells as these can differ and i may not want to remove them.

    Attached is an example file (Obviously with sterilised data)
    If the code works properly then I would expect Rows 7,8 and 11,12 to be removed but all others to remain.
    Apologies for not having any code to work from, normally I can adapt other code with my limited knowledge but in this case I don't know where to start.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-11-2016, 04:02 AM
  2. [SOLVED] Comparing 2 columns and deleting duplicates in the second column according first column
    By wingo033 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-19-2012, 07:14 PM
  3. Replies: 3
    Last Post: 11-09-2011, 12:36 PM
  4. Identifying Duplicates in 2 columns
    By Excel 2007 Newbie 2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2011, 10:49 PM
  5. Comparing Lists and Deleting Duplicates
    By Fcroft in forum Excel General
    Replies: 1
    Last Post: 02-17-2010, 02:01 PM
  6. Identifying Duplicates then deleting them and cells either side
    By raehippychick in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-10-2008, 10:51 AM
  7. [SOLVED] Identifying Duplicates in Columns
    By DamienO in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2006, 02:45 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