+ Reply to Thread
Results 1 to 3 of 3

Clear cells if duplicate

  1. #1
    Forum Contributor
    Join Date
    04-11-2014
    Location
    Norway
    MS-Off Ver
    Office 365 version 2302
    Posts
    152

    Clear cells if duplicate

    Hi all,

    This is probably answered before, I searched for 15 minutes but couldn't find any similar question.


    I need a code to delete duplicates across rows.

    Numbers are listed in Column D & H

    If D1 and H1 are duplicates, I want H1 to be cleared.
    If D2 and H2 are duplicates, I want H2 to be cleared.

    .. and so on until the last row

    Anyone who can help me with this?

    See attached sample.

    Thanks!
    Attached Files Attached Files
    Last edited by goranimo; 10-16-2019 at 07:36 AM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Clear cells if duplicate

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    04-11-2014
    Location
    Norway
    MS-Off Ver
    Office 365 version 2302
    Posts
    152

    Re: Clear cells if duplicate

    AlphaFrog: Works perfectly, 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. VBA to Clear 1 Cell and Clear other cells Formula only
    By oneblondebrow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2017, 12:56 PM
  2. Message box if duplicate found and clear the data from corresponding cells
    By sahal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2015, 06:00 AM
  3. Clear multiple cells in a row if duplicate is found
    By gokica in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2014, 06:35 PM
  4. Delete clear duplicate in A1
    By johnph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2013, 08:42 PM
  5. [SOLVED] Clear every second duplicate value in a column
    By Reny in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2012, 05:49 AM
  6. Duplicate cells, clear data
    By Toddneyx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2011, 07:38 AM
  7. Clear duplicate entries
    By nicko54 in forum Excel General
    Replies: 11
    Last Post: 07-25-2008, 06:44 AM

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