Suppressing Duplicates
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Suppressing Duplicates

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a worksheet that has duplicate entries in several columns, for example, the first column is for "School" and the name of a school repeats many times until it gets to a record on down the list for a different school name. Is there a way to make it so that after the first entry of a school the following cells in that column won't show anything until a new value appears? Thank you.

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could use conditional formatting. Select the second cell in the column (say A2), then Format > Conditional formatting. Choose formula is and enter the formula =A2=A1. Click on format and make the font color white. Click Ok twice to exit. Copy the cell and paste special > format down your column.

  3. #3
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-19 16:19, mason1234 wrote:
    I have a worksheet that has duplicate entries in several columns, for example, the first column is for "School" and the name of a school repeats many times until it gets to a record on down the list for a different school name. Is there a way to make it so that after the first entry of a school the following cells in that column won't show anything until a new value appears? Thank you.
    Yes, use conditional formatting. Select your entire column (say A1 to A100), and go to Format-Conditional Formatting. Then select "Formula Equals", and in the formula box, type:

    =(A1000=A999)

    Use the last and second to last rows, it makes a difference. (or don't select the first row and put =(A2=A1)). Then format the font to white (if your background is white).

    Hope this helps,

    Russell

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mason
    If your school list is in column A, starting at A4, put this formula in B4 and scroll down. This will then only display unique entries.
    =IF(ISNA(VLOOKUP(A4,$A$2:$A3,1,FALSE)),A4,"")
    Derek

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Derek, Russell and Steve,

    Thanks so much! I have tried and these work marvelously. I really appreciate your help. Thanks!

    Merle Mason

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com