![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Feb 2002
Posts: 9
|
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 |
|
Board Regular
Join Date: Feb 2002
Location: Houston,Texas
Posts: 418
|
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 |
|
New Member
Join Date: Feb 2002
Posts: 9
|
Steve,
Works like a charm! Thank You! Merle Mason |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|