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
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