Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Suppressing Duplicates #2

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

    Default

    Yesterday I got some great advice about using conditional formatting (formula is =A2=A1) and font white to conceal duplicates that appear in a column (so a school name wouldn't be repeated until a cell with a new name).
    That worked great for "school" and "course ID" because those are unique. But the column to the right of course ID is "Units." Is there a similar formula I can use so that it won't repeat "3" in that column until a new entry appears in the "course ID" column? So that it will display 3, then not display 3 again until a new course ID appears in the column to the left? Thanks again.
    --Merle Mason

  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

    Sure! Assuming the Course ID is in column C and the Units are in column D, the procedure is the same as your last question but instead of the formula =A2=A1 use =C2=C1 in the second cell of your data incolumn D.

    [ This Message was edited by: Steve Hartman on 2002-02-20 13:20 ]

    [ This Message was edited by: Steve Hartman on 2002-02-20 13:32 ]

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

    Default

    Steve,

    Works like a charm! Thank You!

    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
  •