Error Checking in Excel
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,607
    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,584
    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

Some videos you may like

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
  •