Results 1 to 5 of 5

Need Formula for blank out duplicate cells based on value that is changes in another colum

Threaded View

  1. #1
    Registered User
    Join Date
    08-18-2021
    Location
    UAE
    MS-Off Ver
    365
    Posts
    9

    Need Formula for blank out duplicate cells based on value that is changes in another colum

    Hello

    I'm looking for a formula that would blank out cells in Column B and not delete the entire row when duplicate data is found but the trick is that it needs to be based on when there is duplicate data in column A then it should just keep one value in column B and all other values related to that other column should be blank.

    Column A Column B
    ABC 123
    ABC 123
    ABC 123
    DEF 456
    DEF 456
    DEF 456

    So my result should be like this

    Column A Column B
    ABC 123
    ABC
    ABC

    Thank you.
    Last edited by Waseem0888; 10-06-2021 at 05:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-25-2017, 12:26 PM
  2. [SOLVED] Find last used column in row 1, then autoreplace all blank cells in row 2 UP to that colum
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2014, 02:53 PM
  3. Replies: 2
    Last Post: 10-18-2013, 11:18 AM
  4. Replies: 7
    Last Post: 02-10-2013, 02:10 AM
  5. Create duplicate rows for a single colum with 'x2' or 'x3' are in cells.
    By justchil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2012, 06:15 PM
  6. Replies: 2
    Last Post: 06-26-2010, 06:59 AM
  7. [SOLVED] find range of non-blank cells in colum
    By DJS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2006, 05:30 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