+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Removing duplicates between two text in a column

  1. #1
    Registered User
    Join Date
    09-03-2011
    Location
    India, TN
    MS-Off Ver
    Excel 2003
    Posts
    3

    Removing duplicates between two text in a column

    Hi all,
    I am new to this forumn. I have a problem in removing duplicates. say in a2:a100 i have results like
    yes

    yes

    no
    no

    yes

    no
    yes
    yes
    no
    and so on.
    I want to remove and replace with blank rows for the duplicates comes in between one YES and one NO in that column.leaving already blank rows unaltered.

    I request my seniors in this forum to help me out in this regard
    Thanks in advance
    Last edited by Booba; 09-03-2011 at 02:11 AM. Reason: spelling mistake

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Removing duplicates between two text in a column

    Hello Booba and welcome to the forum,

    There are many examples of removing duplicates on the net. Here are a few of them.
    http://office.microsoft.com/en-us/ex...001034626.aspx
    http://support.microsoft.com/kb/262277
    http://techchand.org/348/easy-steps-...3-2007and-2010

    I hope this helps.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    09-03-2011
    Location
    India, TN
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Removing duplicates between two text in a column

    Hi MarvinP Thanks for your reply i tried with all that links but i could't able to find the exact answer for my problem. If i try to delete duplicates in excel2007 it deletes all Yes and No in my list and gives only one Yes and one no, but my question is different please understand my problem.
    regards

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Removing duplicates between two text in a column

    OK Booba,

    So the question is how to change
    yes

    yes

    no
    no

    yes

    no
    yes
    yes
    no

    Into

    yes



    no


    yes

    no
    yes

    no

    Am I understanding the question now?

    Look at the attached with a helper column to arrive at your anser. Is that what you wanted?

    One of the smart guru's can most likely merge my helper column into a single column formula.
    Attached Files Attached Files
    Last edited by MarvinP; 09-04-2011 at 12:23 AM.

  5. #5
    Registered User
    Join Date
    09-03-2011
    Location
    India, TN
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Removing duplicates between two text in a column

    Hi MarvinP
    Thanks for your excellent help in getting what i want.
    regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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