+ Reply to Thread
Results 1 to 9 of 9

[HELP] me to remove duplicate values and leave that cell as blank

  1. #1
    Registered User
    Join Date
    09-28-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    15

    [HELP] me to remove duplicate values and leave that cell as blank

    Hi,
    as you can see there are some values in the cell A which are duplicated, what I want is to remove duplicated values and put those unique values either in cell B or in cell A, but I also want after removing duplicate cell should remain blank..
    fdsfsdfdsffdsf.jpg

    actually I have data which I want to make unique,

    I know gurus are here to help Thanks for creating such a great forum.
    Last edited by spa3212; 04-29-2015 at 11:41 PM.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: [HELP] me to remove duplicate values and leave that cell as blank

    Confused.....cells B7 & B10 are duplicated values.

    Do you mean something else when you say "remove duplicated values"?

    I thought I saw a pattern 'till I saw "fnal cuttings" only once in column B.
    Last edited by FlameRetired; 04-29-2015 at 11:35 PM.

  3. #3
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    Re: [HELP] me to remove duplicate values and leave that cell as blank

    Hi spa,

    This is not possible through formula, you have to take help of VBA.

    Thanks
    Nisha

  4. #4
    Registered User
    Join Date
    09-28-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: [HELP] me to remove duplicate values and leave that cell as blank

    I corrected the image..

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: [HELP] me to remove duplicate values and leave that cell as blank

    Try this formula in cell B1 and fill down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    File is attached.

    Is this what you are trying to achieve?
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-28-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: [HELP] me to remove duplicate values and leave that cell as blank

    Remove duplicate values.xlsx


    Yes it does solve 99% of my problem, Just getting #value at some place please check this ...

    Many thanks
    Last edited by spa3212; 04-30-2015 at 12:37 AM.

  7. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: [HELP] me to remove duplicate values and leave that cell as blank

    Excel restricts us to a character limit. How this impacts the COUNTIF function I cannot say.

    While I cannot name that limit cell A1 has 889 characters.

    This seems excessively long and I suspect that is the source of this problem. Unfortunately I do not know how to work around this.....perhaps a VBA solution or some other alternative will be offered.

    Sorry I could not assist you further.

  8. #8
    Registered User
    Join Date
    09-28-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: [HELP] me to remove duplicate values and leave that cell as blank

    yes, I tried by removing some text then it works..
    Thanks for solving my problem...

  9. #9
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: [HELP] me to remove duplicate values and leave that cell as blank

    Your welcome....glad you found a solution.

+ 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] How to remove duplicate data but leave the row with highest value from another column
    By mgilmore77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-22-2014, 08:59 PM
  2. [SOLVED] Remove duplicates without removing cells (leave blank)
    By RobertOHare in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2013, 09:57 AM
  3. [SOLVED] delete duplicate in one column, but leave cells blank
    By odieses in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 07-02-2013, 03:32 PM
  4. How can I remove the #NUM from a cell and leave it blank?
    By Sharonits in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2013, 04:16 PM
  5. Replies: 4
    Last Post: 09-18-2012, 09:06 AM

Tags for this Thread

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