+ Reply to Thread
Results 1 to 2 of 2

Replace Duplicates with Blank Values while Keeping the First Instance

Hybrid View

  1. #1
    Registered User
    Join Date
    12-04-2020
    Location
    Antipolo City, Rizal, Philippines
    MS-Off Ver
    Microsoft Office Excel 2019 and 2021
    Posts
    38

    Replace Duplicates with Blank Values while Keeping the First Instance

    I need some help, I am using Excel 2021.

    How can I replace duplicate values with blank cells while keeping the first instance of the cell as it is? It has some values under the "Clean Data (Extracted)" worksheet and I added the formula to extract the values inside the parentheses.

    =LEFT(MID('Original Data'!H2,FIND("(",'Original Data'!H2)+1,LEN('Original Data'!H2)),FIND(")",MID('Original Data'!H2,FIND("(",'Original Data'!H2)+1,LEN('Original Data'!H2)))-1)
    Attached Files Attached Files

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,465

    Re: Replace Duplicates with Blank Values while Keeping the First Instance

    Please try in cell BI2 and copy down and right
    Formula: copy to clipboard
    =IF(COUNTIF($H2:H2,H2)=1,H2,"")
    Attached Files Attached Files

+ 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. [SOLVED] Remove Duplicate - Specific instance but keeping data from removed instance?
    By NewYears1978 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-22-2022, 12:59 PM
  2. Sorting a list alphabetically keeping duplicates+ lookup some values
    By buyshirts in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2015, 04:38 AM
  3. [SOLVED] Replace duplicates with Blank Cells
    By karlosdejackal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2015, 06:22 AM
  4. Find duplicates in column B, keep value from first instance in A, and replace B:H
    By votekinky06 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-31-2014, 04:04 PM
  5. Replies: 6
    Last Post: 03-29-2012, 12:16 AM
  6. Replies: 1
    Last Post: 05-24-2011, 04:04 AM
  7. Excel 2007 : deleting duplicates but keeping row values
    By moldoverb in forum Excel General
    Replies: 6
    Last Post: 10-23-2009, 11:57 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