+ Reply to Thread
Results 1 to 3 of 3

Remove or highlight duplicates

  1. #1
    Registered User
    Join Date
    06-02-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    15

    Remove or highlight duplicates

    Hi all.

    I have a list of 2400 records, I copied and worked on about 500 of them .. but in my infinite wisdom I failed to note them on the original sheet. So I don't want to work on records/call customers I've already worked on. What I'd like to do is compare my 500 records (Target) and remove them from the main sheet. I've tried the "Remove duplicate" function in excel, but it still leaves me with one record.

    In summary, I need to remove the row in the main sheet when it finds and matches in the target sheet.

    Many thanks for any help.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,312

    Re: Remove or highlight duplicates

    Try:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-02-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    15

    Re: Remove or highlight duplicates

    Brilliant, that's done the job. Many thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare lists of URLs for duplicates, and remove duplicates
    By mrfranklin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-13-2018, 05:27 AM
  2. Vba to highlight the cell and remove duplicates
    By ashup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2017, 05:21 AM
  3. [SOLVED] Remove (or Highlight) name duplicates?
    By maurerjl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-14-2015, 01:45 PM
  4. Replies: 12
    Last Post: 09-10-2013, 09:45 PM
  5. [SOLVED] highlight/remove highlight of rows conditional on cellvalue
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2012, 07:14 AM
  6. Replies: 5
    Last Post: 02-28-2012, 02:52 PM
  7. Macro to check for duplicates and highlight duplicates
    By obc1126 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2008, 09:55 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